CREATE OR REPLACE PROCEDURE Login
2 (
3 userID in varchar2,pwd in varchar2,errCode out int
4 )
5 is
num int;
6 begin
7 Select count(*) into num FROM Users Where UserID = userID AND pwd = pwd) > 0;
if num>0
then errCode := 1
9 end
10 /
2 (
3 userID in varchar2,pwd in varchar2,errCode out int
4 )
5 is
num int;
6 begin
7 Select count(*) into num FROM Users Where UserID = userID AND pwd = pwd) > 0;
if num>0
then errCode := 1
9 end
10 /
是不是Select count(*) into num FROM Users Where UserID = userID AND pwd = pwd) > 0;
,多了>0?
Select count(*) into num FROM Users Where UserID = userID AND pwd = pwd) > 0;
改为:
Select count(*) into num FROM Users Where UserID = userID AND pwd = pwd;
(userID in varchar2,pwd in varchar2,errCode out int)
is
num int;
begin
Select count(*) into num FROM Users Where UserID = userID AND pwd = pwd) > 0;
if num>0 then
errCode := 1;
else
errCode := 0;
end if;
end;
/