Update NOTFOUND from PL/SQL

Well, you can put a select right before your update. Then you can put in an exception handler at the bottom of your PL/SQL that executes on the predefined exception NOT_FOUND. If the select returns a not found, the exception handler will execute. I don't know if this is much better than the way you are doing it, but it's an alternative.  

Amy Leone Received on Fri Oct 06 1995 - 00:00:00 CET