Re: Merge Problem

Michel Cadot wrote:
> "mike" <hillmw_at_charter.net> a écrit dans le message de
> news:1111683445.671427.146550_at_o13g2000cwo.googlegroups.com...
> | Most of the transactions 96% will be update transactions, so shouldn't
> | we go ahead and try to update first, and then if it is not there do the
> | insert?
> |
> | begin
> | UPDATE mytable SET role = 'Super' where id='111111';
> | exception when VAL_NOT_FOUND then
> | Insert into mytable (id, role ) values ( '111111','Super' );
> | end;
> |
> | So I need to replace dup_val_on_index with some other exception. Do
> | you know what that exception is?
> |
> | Mike
> |
>
> Your the one that knows the application.
> Of course you should first try what is the most mikely to come.
> The exception name is NO_DATA_FOUND.
>
> Regards
> Michel Cadot
>
>

probably:

update mytable set role = 'Super' where id = '111111'; if sql%rowcount = 0 then

    insert into mytable (id, role) values ('11111','Super'); end if;

.....

Anurag Received on Thu Mar 24 2005 - 21:20:59 CST