Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Select into problem
Jun wrote:
> Hi Guys,
>
> I have a question about PL/SQL code
>
> I have the following select into statement :
>
> SELECT STUD_AGE INTO v_cHP_MaxAge FROM STUDENT WHERE GDU =
> '015346001002';
>
> I know It has no value returned but it give a no_data_found error.
> How do I escape that error without using exception?
> Is there any way to force the query return some value instead of an
> error?
>
> Thanks in advance
Why can't you use an exception? Try using CASE, NVL, or NVL2 in the statement. Open the 9i or 10g SQL Reference. Received on Tue Dec 12 2006 - 15:49:18 CST