Home » SQL & PL/SQL » SQL & PL/SQL » Calling Stored Procedure from a trigger
Calling Stored Procedure from a trigger [message #36848] Thu, 27 December 2001 00:21 Go to next message
Messages: 2
Registered: December 2001
Junior Member
With reference to the subject mentioned, I wish to call an Oracle stored procedure in a trigger body.
I have tried using execute immediate and CALL statements, but an error occurs during execution of the trigger.
The trigger is a row-level after insert.
Anybody got any other ideas?
Iam using the following syntax :
execute immediate 'proc_name(l1,l2);';
CALL proc_name(l1,l2);
Hope i get a positive reply that works

Re: Calling Stored Procedure from a trigger [message #36850 is a reply to message #36848] Thu, 27 December 2001 08:01 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member

is current syntax.(with out CALL or execute immediate)

Previous Topic: Re: Confuse with arrays.
Next Topic: 8613993
Goto Forum:

Current Time: Sat May 25 15:26:29 CDT 2024