How to call a stored procedure inside a trigger? Give an
example.
Answer Posted / 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 |
Post New Answer View All Answers
How to execute a stored program unit?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
How to use like conditions in oracle?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
Which are the five query types available in oracle?
Explain parameter file in oracle.
How do I start tns listener?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What is Virtual Private Database in Oracle?
What is dynamic proxy?
How to create a testing table in oracle?
How to assign data of the deleted row to variables?
How to update values on multiple rows in oracle?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What operating systems are supported by oracle database 10g xe?