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
11849 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

How to loop through a cursor variable?

1080

Is oracle a programming language?

981

What is using clause and give example?

1028

11. Display the client number and name and the client number and name of the person who referred that client.

2329

What is Reduced List of Values?

2158

What is a trigger oracle?

1082

What is MTTR advisor in Oracle?

1086

Differentiate between function and procedure in oracle.

1069

What is index in Oracle?

1065

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1061

Can we store pictures in the database and if so, how it can be done?

1026

Difference between the “verify” and “feedback” command?

1358

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2055

Explain the types of exception?

1139

Can we use bind variables in oracle stored procedure?

945