create or replace procedure test
(unid int number,username in varchar)
is
ls_sql varchar2(4000);
v_unid number,
v_username varchar2(4000);
beginv_unid:=unid;
v_username:=username;
droptable('sms_send_user_temp');
ls_sql:='
insert into table_name(unid,username) values ('||v_unid||','||v_username||')';
execute immediate ls_sql;
commit;
end test;
(unid int number,username in varchar)
is
ls_sql varchar2(4000);
v_unid number,
v_username varchar2(4000);
beginv_unid:=unid;
v_username:=username;
droptable('sms_send_user_temp');
ls_sql:='
insert into table_name(unid,username) values ('||v_unid||','||v_username||')';
execute immediate ls_sql;
commit;
end test;
存储过程插入数据样例:
CREATE OR REPLACE PROCEDURE insert_usersyan(unid INT,
username VARCHAR2,
userpass VARCHAR2,
uname VARCHAR2,
sex VARCHAR2,
company VARCHAR2,
dept VARCHAR2,
job VARCHAR2,
telephone VARCHAR2,
email VARCHAR2,
MSN VARCHAR2,
QQ VARCHAR2) IS
BEGIN
INSERT INTO usersyan
(unid, username, userpass, uname, sex, company, dept, job, telephone, email, MSN, QQ)
VALUES
(i_unid,
i_username,
i_userpass,
i_uname,
i_sex,
i_company,
i_dept,
i_job,
i_telephone,
i_email,
i_MSN,
i_QQ);
COMMIT;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;