Home » SQL & PL/SQL » SQL & PL/SQL » Problem with trigger
Problem with trigger [message #267667] Fri, 14 September 2007 02:55 Go to next message
donind
Messages: 95
Registered: February 2007
Member
HI,


I have a trigger calling a procedure. To call a procedure with in trigger i have wriiten below statement

call proc1(arg1);

Its giving an error. When i remove call its working fine. I dont know what the problem is.

I am not able to understand when to use call and not in a trigger to call a procedure.

whats actually the diffence between these two calls.Any example will really help.

Thanks in advance.
Re: Problem with trigger [message #267669 is a reply to message #267667] Fri, 14 September 2007 03:00 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There's no problem at all. Procedures in PL/SQL scripts are called by naming them (just as you did when you removed the 'call'). CALL is used for this (call a routine from SQL (not PL/SQL)).
Re: Problem with trigger [message #267670 is a reply to message #267667] Fri, 14 September 2007 03:00 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
If you add "call" it does not work, if you remove it it does work. I think it is pretty clear what you should do. Also, why should we provide another example since you have such a wonderful example already?

call is sqlplus syntax.

[Edit: Again, Littlefoot worded it much clearer than I did]

[Updated on: Fri, 14 September 2007 03:01]

Report message to a moderator

Previous Topic: Grant and Revoke commands
Next Topic: Problem with Procedure
Goto Forum:
  


Current Time: Sat Dec 03 22:39:33 CST 2016

Total time taken to generate the page: 0.08483 seconds