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 -> Select Into doesn't work properly

Select Into doesn't work properly

From: Dirk his Linux bakje <d.joosen_at_planetinternet.nl>
Date: Wed, 12 Jan 2000 08:58:33 +0100
Message-ID: <387C3429.C099DE6A@planetinternet.nl> 





Hi



I have a problem with a stored procedure where I declared an Select Into
statement like:


l_num NUMBER;


SELECT ID_1 INTO l_num FROM TABLE WHERE  ID_2 = INPUT_PARAMETER;
This occurs in a ORA-01422: exact fetch returns more than requested
number of rows.



When I type in PL/SQL the statement:


SELECT ID_1 FROM TABLE WHERE  ID_2 = INPUT_PARAMETER;

Then the PL/SQL says: no rows selected


You see PL/SQL has no problems.



What do I wrong,?


Thanks and with best regards


Dirk Joosen


Received on Wed Jan 12 2000 - 01:58:33 CST












Original text of this message













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