Re: Select into problem

On Tue, 12 Dec 2006 13:32:50 -0800, Jun wrote:

> SELECT STUD_AGE INTO v_cHP_MaxAge FROM STUDENT WHERE GDU =
> '015346001002';

SELECT STUD_AGE INTO v_cHP_MaxAge FROM (   SELECT STUD_AGE FROM STUDENT WHERE GDU = '015346001002'   UNION
  SELECT -1 AS STUD_AGE FROM DUAL
);

That will never throw "NO_DATA_FOUND" exception.

-- 
http://www.mladen-gogala.com