Re: SQL-02112 SELECT ... INTO returns too many rows --- how to use the SELECT

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL-02112 SELECT ... INTO returns too many rows --- how to use the SELECT_ERROR option??

From: <sigdock_at_my-deja.com>
Date: Wed, 10 Jan 2001 09:53:01 GMT
Message-ID: <93hbdr$cgd$1@nnrp1.deja.com>

A good solution but it might still cause a ora-01403, no data found, error. This means you have to handle that exception. Another way is to declare a cursor with an 'order by' clause and then fetch this cursor. A bit more work but if you make this a standard way of working you'll get used to it quite fast.

regards,
BertJan Meinders

In article <qglm5tge3nc0oipoinr44ctli3nitp3s8m_at_4ax.com>, Todd Barry <toddbarry_at_earthlink.net> wrote:
> >I'm getting the following error when executing one of my stored
procedures:
> >
> >SQL-02112 SELECT ... INTO returns too many rows
> >
> >I just require the first record that is returned by the select
statement and
> >wish to discard the rest.
>
> Just add on the ROWNUM qualifier:
>
> select col1
> into var1
> from table1
> where col2 = something
> and rownum = 1;
>
> -Todd
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 10 2001 - 03:53:01 CST