Re: no matching record for update or delet in pl/sql

From: daMax <stevemax_at_rogers.com>
Date: Sat, 08 Dec 2001 02:01:45 GMT
Message-ID: <dweQ7.954$JL11.400@news2.bloor.is>

use SQL%FOUND or SQL%NOTFOUND immediately after the update/delete statement.

eg.
Delete <table> where <condition>;
if SQL%FOUND then
......
end if;

"jim" <winw56_at_yahoo.com> wrote in message news:6631ab8f.0112071141.7fda1c69_at_posting.google.com...
> jim agans
>
> matching record for update or delet in pl/sql
>
> Hello....
>
> I would like to find if it is possible to check to see if a update or
delet
> statement in oracle found a matching record to operate on.
> The EXCEPTION wont pick it up ..( you get a msg "0 records deleted " or
> "0 records updated ") Is there a way to pick this up to notify a user??
Received on Fri Dec 07 2001 - 20:01:45 CST