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 would you want to circumvent the normal exception handling mechanism.

If nothing is returned what do you want to result to be? That v_cHP is NULL or has some other value? Do you want processing to just continue?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org