OraFAQ Forum: SQL & PL/SQL » Calling Stored Procedure from a trigger

Home » SQL & PL/SQL » SQL & PL/SQL » Calling Stored Procedure from a trigger

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Calling Stored Procedure from a trigger [message #36848]

Thu, 27 December 2001 00:21

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

----------------------------------------------------------------------

Report message to a moderator

Re: Calling Stored Procedure from a trigger [message #36850 is a reply to message #36848]

Thu, 27 December 2001 08:01

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

proc_name(l1,l2);

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

----------------------------------------------------------------------

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 22:28:28 CST 2024