Use of varchar2 - please help!

The problem is, it seems to me the two methods below are identical. The first one yields at outcode of 17, while the second yields an outcode of 12. The user with that username/password IS in the database. Why doesn't the first method yield a 12?

Please help!

• Dan

  ---

  declare

uname varchar2(20) := 'bobmeister';
pwd varchar2(20) := 'godgod';
outcode integer;

• Method 1 cursor theuser is select * from users where(username = uname and password = pwd);
• Method 2
  --cursor theuser is select * from users where(username = 'bobmeister'
  and password = 'godgod');

userval theuser%rowtype;

begin

delete from test2;

 open theuser;
 fetch theuser into userval;

 if theuser%found then
  outcode := 12;
 else
  outcode:=17;
 end if;

 delete from test;
 insert into test values(outcode);

 close theuser;
end;
/ Received on Mon Jun 14 1999 - 23:37:56 CDT