Update statement never throw no_data_found exception
you have to use SQL%Rowcount to find out how many records has been updated

Update ...
If SQL%rowcount = 0
then
insert statement
end if;

----- Original Message -----
From: "Carlos Barrera "
<oracledba-ezmlmshield-x40769484.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, April 06, 2005 10:23 AM
Subject: pl/sql question


>
> the following code is not working properly. when the record doesn't
> exist,
> it's not inserting it. do i have to use another exception instead of
> no_data_found?
>
> regards.
>
> begin
> update table a
> set ...
> where...
> exception when no_data_found then
> insert into table a ...
> end;
> commit;
>
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>


Oracle LazyDBA home page