Re: Select into problem

From: Michael O'Shea <michael.oshea_at_tessella.com>
Date: 13 Dec 2006 06:08:36 -0800
Message-ID: <1166018916.431207.160870@j44g2000cwa.googlegroups.com>

Mladen Gogala wrote:

> 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

Mladen Gogala wrote:

> That will never throw "NO_DATA_FOUND" exception.

Of course you are right Mladen. But if GDU '015346001002' is present in table STUDENT, your query will return two rows meaning a "fetch returned more than requested number of rows" error. The OP will have to limit the rows returned to one, and the right one.

Regards,
Mike

TESSELLA Michael.OShea_at_tessella.com

__/__/__/  Tessella Support Services plc
__/__/__/  3 Vineyard Chambers, ABINGDON, OX14 3PX, England
__/__/__/  Tel: (44)(0)1235-555511  Fax: (44)(0)1235-553301

www.tessella.com Registered in England No. 1466429 Received on Wed Dec 13 2006 - 08:08:36 CST