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 15:17:14 +0100
Message-ID: <aqb89c$8a954$1@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 - 08:17:14 CST

Original text of this message

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