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 are the different approaches used by Optimizer in choosing an execution plan ?
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
How do I find my oracle client driver version?
What are the commands youd issue to show the explain plan for select
10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.
How many types of tables are there in oracle?
What is the recommended interval at which to run statspack snapshots, and why?
How to drop an existing table in oracle?
What is the sql query to concatenate column values from multiple rows in oracle?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
What is a server parameter file in oracle?
What is the use of Control File ?