Create or Replace Procedure Prc_A(
user_id in varchar2,
user_pwd in varchar2,
check_out out number
)
As
tmp_pwd varchar2(20);
Begin
-- 验证密码之前可以先验证用户名称;
--
-- 验证密码
select password into tmp_pwd from s_user where id = user_id;
if tmp_pwd = user_pwd then
check_out := 1;
else
check_out :=0;
end if;
End;