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
Suhas
Messages: 2
Registered: December 2001
Junior Member
Hi,
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
Luv
Suhas

----------------------------------------------------------------------
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
proc_name(l1,l2);

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

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


Current Time: Mon Aug 03 05:20:20 CDT 2020