Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL with select into returning no rows
Try writing an exception handler for the embedded cursor, using the PL*SQL implicit variable NO_ROWS_FOUND. That way, you can have it continue when no rows are found. This is assuming this is writing a stored procedure with PL/SQL.
Good luck,
Ed
On Fri, 14 Mar 1997 19:17:18 -0500, Jim Finch <jbfinch_at_akron.infi.net>
wrote:
>I have a oracle procedure that has two cursors one embedded in the
>other. In the cursors I have a select into statement. When I run this
>procedure I get an "no rows returned" error on the select. I want to
>have the procedure to keep executing in this condition but can't seem to
>get it to work. The server is 7.2.3. The procedure will be run on the
>server.
>
>Any help is appreciated in advance
>
>jbfinch_at_akron.infi.net
Received on Mon Mar 17 1997 - 00:00:00 CST