create or replace procedure insert_user_information
(
p_user_login_name in varchar2,
p_user_password in varchar2,
p_user_name in varchar2,
p_user_telephone in varchar2,
p_user_type in number,
p_out out number
) as
v_count number;
begin
if p_user_login_name is null or p_user_password is null then
p_out:=-1; -- 用户名和密码不能为空,
return ;
end if;
if p_user_type is null then p_out:=-2; -- 用户类型不能为空
return ;
end if;
select count(*) into v_count from user_information a where .user_login_name=upper(p_user_login_name);
if v_count>0 then
p_out:=-3; -- 该用户名已经存在
return ;
end if;
insert into user_information
values(seq_user_information.nextval,upper(p_user_login_name), p_user_password,p_user_name,p_user_telephone,p_user_type, sysdate,sysdate);
commit;
p_out:=0; -- 操作成功
return ;
exception
when others then
p_out:=-4; -- 插入过程中出现异常
return ;
end ;
(
p_user_login_name in varchar2,
p_user_password in varchar2,
p_user_name in varchar2,
p_user_telephone in varchar2,
p_user_type in number,
p_out out number
) as
v_count number;
begin
if p_user_login_name is null or p_user_password is null then
p_out:=-1; -- 用户名和密码不能为空,
return ;
end if;
if p_user_type is null then p_out:=-2; -- 用户类型不能为空
return ;
end if;
select count(*) into v_count from user_information a where .user_login_name=upper(p_user_login_name);
if v_count>0 then
p_out:=-3; -- 该用户名已经存在
return ;
end if;
insert into user_information
values(seq_user_information.nextval,upper(p_user_login_name), p_user_password,p_user_name,p_user_telephone,p_user_type, sysdate,sysdate);
commit;
p_out:=0; -- 操作成功
return ;
exception
when others then
p_out:=-4; -- 插入过程中出现异常
return ;
end ;