Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

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

From: Todd Barry <toddbarry_at_earthlink.net>
Date: Wed, 10 Jan 2001 19:59:48 GMT
Message-ID: <5hfp5tspblqo5r8e751qbrneddjsradub6@4ax.com> 






>I've been able to use this method on most of my queries but on some the

>ordering is critical and the ROWNUM kicks in before the ordering is taken

>into account.

>

>Any further ideas??




If the order is important, then you will need to do a cursor
open/single fetch/close sequence to get the single value for which you
are looking.



-Todd
Received on Wed Jan 10 2001 - 13:59:48 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US