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

>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 Received on Tue Jan 09 2001 - 12:20:49 CST