PL/SQL Newbie Question

I have a SELECT statement that returns, at most, 1 row in a procedure. When the select doesn't return a row (NO_DATA_FOUND) I want to set the variable that recieves the column value to a space (' ') and go on with the rest of the logic in the procedure. What happens is that the procedure exits. How can I prevent this?

Thanks for your help... Received on Fri Sep 10 1999 - 18:33:47 CDT