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 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 called procedure
was successful
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
