Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PL/SQL Newbie Question

PL/SQL Newbie Question

From: <rocko_at_cosmos.com>
Date: Sat, 11 Sep 1999 00:17:53 GMT
Message-ID: <37d99340.88911@news.netset.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US