Interested to Buy Any Domain ? << Click Here >> for more details...
How to call a stored procedure inside a trigger? Give an
example.
- 1 Answers
- 11766 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 compare dates in oracle sql?
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?
What are the advantages of oracle?
What is oracle open database communication (odbc)?
Can you assign multiple query result rows to a variable?
How to drop an index?
Explain database link?
How to use "in" parameter properly?
I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.
State all possible different index configurations a table can possibly have?
How do I know if oracle is installed on windows?
What is data block in Oracle?
Oracle General 
