Using Call keyword we can call procedure inside trigger. e.g. CREATE OR R

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

Question Posted / pardeep

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

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1790

What is tns name?

928

Can you create a synonym without having a table?

980

Which is faster join or subquery in oracle?

934

What is an oracle database?

991

What are ddl statements in oracle?

1018

How to count duplicated values in a column in oracle?

985

Explain oracle insert into command?

1056

What is dual table oracle?

927

What language does oracle use?

1049

What are the differences between primary key and unique key?

949

How to empty your oracle recycle bin?

982

Will you be able to store pictures in the database?explain.

930

What is the purpose of tables, private synonyms and public synonyms in Oracle?

980

How to define default values for formal parameters?

985