Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: select into NULL in PL/SQL
i guess you could use the NVL function to decode your nulls into something else (e.g., an impossible value that you would recognize was decoded from null). this way you avoid the no_data_found execption. then perform your logic accordingly.
otherwise, you need to handle the exception with standard pl/sql exception handling methods.
hth Received on Wed Jun 27 2001 - 10:09:47 CDT