I want a TOO_MANY_ROWS error

From: sven <sbraem_at_levi.com>
Date: 6 Nov 2002 02:49:23 -0800
Message-ID: <48ca1f99.0211060249.346eb6c8@posting.google.com>

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? Received on Wed Nov 06 2002 - 04:49:23 CST