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 |
which is best institue to learn oracle 11i in ameerpet or maithrivanam or sr nagar please help
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What is the difference between post-database commit and post-form commit?
What are the tools for Oracle ?
How to convert characters to numbers in oracle?
What are the advantages of oracle 12c?
what are the database links ?
How to define a variable to match a table column data type?
how to tune oracle sql queries pls tell me step by step. urgent pls
What is the scope of a local variable?
what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval
What is Partitions in Table ?