Re: How do I know if UPDATE fails?

nobody <nobody_at_nowhere.com> wrote:

: create or replace procedure ab is
: begin
: update junk
: set points=4
: where points=5;
: if sql%rowcount=0 then
: dbms_output.put_line('not updated');
: end if;
: end;

Thank you! I had completely forgotten about those implicit cursor attributes. :-)

I think an alternative would be to use %found or %notfound as well. Received on Wed Feb 26 2003 - 07:47:31 CST