create or replace procedure Portal_UserLogin
(
pEmail in varchar2,
pPassword in varchar2,
pUserName out varchar2,
pUserID out number,
pColorIndex out number
)
as
begin
SELECT
Name into pUserName,
UserID into pUserID
Colorindex into pColorIndex
FROM portal_users
where Email = pEmail AND Password = pPassword;
end;我就是想给pUserName ,pUserID, pColorIndex赋值,怎么就不好使呢?
提示From 没有得到期望的值!
(
pEmail in varchar2,
pPassword in varchar2,
pUserName out varchar2,
pUserID out number,
pColorIndex out number
)
as
begin
SELECT
Name into pUserName,
UserID into pUserID
Colorindex into pColorIndex
FROM portal_users
where Email = pEmail AND Password = pPassword;
end;我就是想给pUserName ,pUserID, pColorIndex赋值,怎么就不好使呢?
提示From 没有得到期望的值!
Name into pUserName,
UserID into pUserID
Colorindex into pColorIndex ---一个INTO就OK了
FROM portal_users
where Email = pEmail AND Password = pPassword;SELECT
Name,UserID,Colorindex into pUserName, pUserID, pColorIndex
FROM portal_users
where Email = pEmail AND Password = pPassword;
(
pEmail in varchar2,
pPassword in varchar2,
pUserName out varchar2,
pUserID out number,
pColorIndex out number
)
as
begin
SELECT
Name,
UserID,
Colorindex into pUserName,pUserID,pColorIndex
FROM portal_users
where Email = pEmail AND Password = pPassword;
end;