change the query...
SELECT count(STUD_AGE),STUD_AGE INTO numcount,v_cHP_MaxAge FROM
STUDENT WHERE GDU = '015346001002' group by STUD_AGE I think should work
....
but... why don't catch the exception ?
PP
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
>
Received on Sun Dec 17 2006 - 15:36:57 CST
