Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL-02112 SELECT ... INTO returns too many rows --- how to use the SELECT_ERROR option??
Thanks for the info guys....I take it there is no way to set precompiler options inline within a PL\SQL block.
Dave
<sigdock_at_my-deja.com> wrote in message news:93hbdr$cgd$1_at_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 - 04:15:01 CST