Test the result of an UPDATE

[Josselin]

Hi all,

When performing an UPDATE on an Oracle table, I want to know if the update was really done or not.
If the record does not exist, nothing will be done.
If the record exists, the update will be performed.
I can catch the result if the UPDATE fails in the EXCEPTION clause, but I don't know how to proceed if the record does not exist.

I think I can test an Oracle variable, but I really don't remember what.

Thanks for your input.

Josselin.

 

[sem]

SQL%ROWCOUNT contains the number of rows affected by the latest sql statement.

Regards, Dima

http://seminihin.narod.ru