CREATE OR REPLACE PROCEDURE Proc_nc_cg
(insertid IN varchar2,
retcode IN varchar2,
retname IN varchar2,
rettype IN varchar2,
retrecordmsg IN varchar2,
retexception IN varchar2)
IS
BEGIN
dbms_output.Put_line('insertid'||insertid);
INSERT INTO ini_ins_trans_his SELECT * FROM ini_ins_trans t WHERE t.insert_id in(insertid);
COMMIT;
EXCEPTION
WHEN OTHERS THEN
dbms_output.Put_line(SQLCODE || 'Proc_nc_cg exec error' ||sqlerrm);
ROLLBACK;
END proc_nc_cg; 输出报错
insertid1443,1444,1445
-1722Proc_nc_cg exec errorORA-01722: invalid number
如何解决这个问题啊?