Select into problem

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 Tue Dec 12 2006 - 15:32:50 CST