会提示num不能作为into的添加目标
create or replace procedure user_add (
resultStr out char,
v_username in CHAR,
v_userid in CHAR,
v_password in CHAR,
v_id_number in VARCHAR2,
v_roleid in CHAR,
num in char
) is
Begin
select userid into num from userinfo where userid!='';
if v_userid = num then
insert into userinfo(username,userid,password,id_number) values(v_username,v_userid,v_password,v_id_number);
insert into user_role(userid,roleid) values(v_userid,v_roleid);
ResultStr := 'success: 添加成功!';
else
ResultStr := 'success: 用户名已存在!';
end if;
End;