Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> PL/SQL Newbie Question
I have a SELECT statement that returns 1 row in a procedure. I want to
just set the variable that holds the column value to a space(' ') if
the SELECT does not return a row (NO_DATA_FOUND) and go on with the
logic. However when I get the NO_DATA_FOUND exception the procedure is
exited. How do I prevent this?
Thanks for your help..
"Let us pass over the river, and rest
Under the shade of the trees." Received on Fri Sep 10 1999 - 19:17:53 CDT
![]() |
![]() |