Re: I want a TOO_MANY_ROWS error

Matthias Rogel <rogel_at_web.de> wrote in message news:<aqbbm1$828ms$1_at_ID-86071.news.dfncis.de>...
> sorry, i got it.
>
> how are v_userid and v_password defined ?

v_userid tmp_pw.userid%type;
v_password tmp_pw.password%type;

But now it is working as it should !?! And I'm sure that there were was more then 1 row returned, otherwise it wouldn't raise the error with the extra check on rowcount. The only thing I can think of is adding the value in the db probably without the commit (doh) and then trying to have the error. But I'm 100% sure that from the moment I've built in the rowcount check that the error was raised and without performing a commit. Writing a piece of code and then test it is how I work so... Anyway, thanks for helping guys. Received on Thu Nov 07 2002 - 03:21:37 CST