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 |
Is postgres faster than oracle?
What is Database Buffers ?
What is a tns service name?
What is oracle open database communication (odbc)?
Which of the following is not a database object TABLESPACE TABLE INDEX NONE
How to synchronize 2 schema's objects?
What is a select query statement in oracle?
14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth
What is oracle host variable?
What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?
What happens if recursive calls get out of control?
what are the advantages of running a database in archive log mode?