How to call a stored procedure inside a trigger? Give an example.

How to call a stored procedure inside a trigger? Give an
example.

Question Posted / dibyajiban

1 Answers
11934 Views
Exilant, I also Faced
E-Mail Answers

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

Post New Answer

More Oracle General Interview Questions

What is the oracle implicit cursor?

0 Answers

consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?

1 Answers

what is view?

7 Answers Accenture,

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

0 Answers Oracle,

What is BBED in Oracle?

0 Answers MCN Solutions,

DBMS vs. RDBMS

2 Answers TCS,

State the various uses of dbcc command?

0 Answers

What to do if the startbd.bat failed to start the xe instance?

0 Answers

How to drop an index in oracle?

0 Answers

what is reindexing?