这么点事还写存储过程? select username from userInfo where username='admin'
--t.name t.pwd create or replace package head as begin function checkLogon(uname t.name%type, upwd t.pwd%type) return boolean; end; / create or replace package body as begin function checkLogon(uname t.name%type, upwd t.pwd%type) as temp number(1); begin select 1 into temp from t where name=uname and pwd=upwd; return true; exception when no_data_found then return false; end;
select username from userInfo where username='admin'
create or replace package head as
begin
function checkLogon(uname t.name%type, upwd t.pwd%type) return boolean;
end;
/
create or replace package body as begin
function checkLogon(uname t.name%type, upwd t.pwd%type) as
temp number(1);
begin
select 1 into temp from t where name=uname and pwd=upwd;
return true;
exception
when no_data_found then
return false;
end;