How to call a stored procedure inside a trigger? Give an
example.
Answer / pardeep
Using Call keyword we can call procedure inside trigger.
e.g.
CREATE OR REPLACE TRIGGER foo
BEFORE DELETE OR INSERT OR UPDATE ON <<table_name>>
FOR EACH ROW
BEGIN
CALL PROCEDURE_NAME();
END;
/
| Is This Answer Correct ? | 16 Yes | 5 No |
How to rename an index?
How many categories of data types?
Explain compound trigger in oracle?
When can Hash Cluster used ?
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
In the oracle version 9.3.0.5.0, what does each number shows?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
what is null value?
How to rename an existing table?
How to create DSN..Explain?
2 Answers Accenture, BeBo Technologies, Infosys,
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
How to connect the oracle server as sysdba?