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
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;
You can raise user defined exception when there are no records updated by
checking the value of SQL%ROWCOUNT.
for example
declare
x number;
no_data exception;
begin
update a set c1 = 2 where c1 = 6;
x := sql%rowcount;
if x = 0 then
raise no_data;
Don't think you get an exception as such but I think you can use %FOUND or
%ROWCOUNT
-Original Message-
Sent: 09 May 2001 17:46
To: Multiple recipients of list ORACLE-L
Hi all,
Do you know if an exception is raised for 0 rows updated.
Take the following scenario but using PL/SQL.