RE: pl/sql exception and whenever sqlerror

2002-08-16 Thread Jacques Kilchoer
Title: RE: pl/sql exception and whenever sqlerror (see answer below - What a difference, a raise makes!) -Original Message- From: Baker, Barbara [mailto:[EMAIL PROTECTED]] I have a command procedure running a sql*plus script that then runs a stored procedure. (This is VMS

pl/sql exception and whenever sqlerror

2002-08-14 Thread Baker, Barbara
OK, I admit up front I'm not a pl/sql programmer. And I really did try to look this up. Honest. Took me a VERY long time to figure this out, but here it is... I have a command procedure running a sql*plus script that then runs a stored procedure. (This is VMS, but I think it would work the

RE: pl/sql exception and whenever sqlerror

2002-08-14 Thread Khedr, Waleed
As long the exception handler is catching the error then the code is assumed to run successfully and no errors should be detected anywhere. If you are still interested in handling this error outside the code, then you can raise an exception from inside the exception handler: begin null;

Re: pl/sql exception and whenever sqlerror

2002-08-14 Thread Tim Gorman
Barb, Hee hee! Oldest PL/SQL mistake in the book -- to handle an exception improperly without passing it on... It sounds like the duhveloper coded the exception block as follows: exception when others then dbms_output.put_line('A serious error has occurred'); end;