Interested to Buy Any Domain ? << Click Here >> for more details...
How to call a stored procedure inside a trigger? Give an
example.
- 1 Answers
- 11848 Views
- Exilant, I also Faced
- E-Mail Answers
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 |
How to bring a tablespace online?
What is SYSTEM tablespace and When is it Created?
What are operators in oracle?
What are the different types of record groups in oracle? Explain each of them
How to create a table interactively?
Will you be able to store pictures in the database?
which is best institue to learn oracle 11i in ameerpet or maithrivanam or sr nagar please help
What are the attributes of the cursor?
Is it possible to split the print reviewer into more than one region ?
What is the use of file param in imp command?
How to convert characters to dates in oracle?
What are the execution control statements in oracle?
Oracle General 
