Hello kranti,
What about error handling?
Wednesday, May 01, 2002, 2:43:23 PM, you wrote:
kp Hi list,
kp I have writeen a stored procedure to execute a set of stored
kp procedures. I want to know is there any way to stop the procedure after any
kp of stoed procedure( from the set)
Hi Kranti,
You have to add out parameter in your procedure call and to test returned
value in main procedure.
Example:
proc1( back_val OUT PLS_INTEGER, blahblah IN VARCHAR2)
AS
BEGIN
...
back_val := 1;
RETURN;
EXCEPTION
WHEN OTHERS THEN
back_val := 0;
END;
proc2( back_val OUT
kranti pushkarna wrote:
Hi list,
I have writeen a stored procedure to execute a set of stored
procedures. I want to know is there any way to stop the procedure after any
of stoed procedure( from the set) returns an error.
In simple words, is it possible to get a status whether the
Use Exceptions...
Ex.
Begin
StroedProc1
StoredProc2
Exception
When Others Then
Error Raised .. Aborting...
End;
HTH
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
I am doing the same but I don't know why stored procedure's( the called
proc) error is not handled in my block. It is coming out of PL/sql block
sayin that my procedure is invalid.
STAARSHIP TECHNOLOGIES
www.staarship.com
That means That the Procedure is invalid ... ;-D
Try to Compile the procedure and see what error u'r getting that may help.
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
Live to