Re: I want a TOO_MANY_ROWS error

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:02:48 CST