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

Home -> Community -> Usenet -> c.d.o.misc -> Re: I want a TOO_MANY_ROWS error

Re: I want a TOO_MANY_ROWS error

From: Matthias Rogel <rogel_at_web.de>
Date: Wed, 06 Nov 2002 16:15:11 +0100
Message-ID: <aqbbm1$828ms$1@ID-86071.news.dfncis.de>


sorry, i got it.

how are v_userid and v_password defined ?

Stéphane ROMANET wrote:

> between password and v_userid on the first line of the query ...
> 
> Stef
> 
> "Matthias Rogel" <rogel_at_web.de> a écrit dans le message de news:
> aqb89c$8a954$1_at_ID-86071.news.dfncis.de...
> 

>>sven wrote:
>>
>>>Hi,
>>>
>>>As I can read in the documentation I should get an error when there is
>>>more then one row selected in a select into statement. Somehow I
>>>don't get the error and have to check for it and raise it myself.
>>>This is in Oracle forms 6i but that shouldn't make a difference right?
>>>
>>>select userid, password into v_userid, v_password
>>>from tmp_pw
>>>where userid = :txtusername;
>>>if SQL%ROWCOUNT > 1 then
>>>raise TOO_MANY_ROWS;
>>>end if;
>>>
>>>The table is filled with 2 of the same userid's. The selection puts
>>>the first row into the variables and that's it. If I don't check with
>>>%ROWCOUNT everything runs fine but it shouldn't.
>>>
>>>Is there something I didn't think of?
>>
>>hi sven,
>>
>>where is the "into" in your select ?
>>
>>mr
>>
> 
> 
> 
Received on Wed Nov 06 2002 - 09:15:11 CST

Original text of this message

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