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 |
What is concurrency in oracle?
Calculate difference between 2 date / times in oracle sql?
How to update a table row with a record?
How to install oracle database 10g xe?
How many types of segments in Oracle?
What are data pump export and import modes?
How do you store pictures in a database?
What is OCI. What are its uses?
What is parameterized cursor in oracle?
What are joins..how many types of joins are there?
29 Answers Amdocs, CSC, TCS,
How to use null as conditions in oracle?
Is there an oracle sql query that aggregates multiple rows into one row?