create or replace procedure P_CREATE_USER(
p_username in VARCHAR,
p_password in VARCHAR,
p_mobile in VARCHAR,
id OUT NUMBER
) as
v_now date:=sysdate;
BEGIN
SELECT USERS_SEQ.NEXTVAL INTO id FROM DUAL;
INSERT INTO USERS
(ID,USERNAME,PASSWORD,MOBILE )
VALUES
(id,p_username,p_password,p_mobile);
COMMIT;
END P_CREATE_USER;
怎么调用
p_username in VARCHAR,
p_password in VARCHAR,
p_mobile in VARCHAR,
id OUT NUMBER
) as
v_now date:=sysdate;
BEGIN
SELECT USERS_SEQ.NEXTVAL INTO id FROM DUAL;
INSERT INTO USERS
(ID,USERNAME,PASSWORD,MOBILE )
VALUES
(id,p_username,p_password,p_mobile);
COMMIT;
END P_CREATE_USER;
怎么调用
P_CREATE_USER(参数);
end ;
username varchar2(20);
password varchar2(20);
mobile varchar2(20);
myid number(10,0);
begin
username:='user';
password:='pass';
mobile :='18910010121';P_CREATE_USER(username,password,mobile, myid);end;
然后在调用存储过程的时候,id=p_create_user(...)