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
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
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;
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;