"yjdabc (就是一个软件工人) "你好!存储过程参数之间的间隔用的是逗号不是分号create or replace procedure mhubpe_GetLoginUser ( ploginName pe_user.loginname%type, pPassword pe_user.password%type, cur_OUT OUT Cursor, refOut OUT refcursor) ) as BEGIN open cur_OUT for select user_id,usertypeid,firstname from pe_user where loginname = ploginName and password = pPassword; end; Thanks Hima
(
ploginName pe_user.loginname%type,
pPassword pe_user.password%type,
cur_OUT OUT Cursor,
refOut OUT refcursor)
)
as
BEGIN
open cur_OUT for select user_id,usertypeid,firstname from pe_user
where loginname = ploginName and password = pPassword;
end;
Thanks
Hima