H
HL-HB
Unregistered / Unconfirmed
GUEST, unregistred user!
create or replace procedure ExecInsert(InsSql in String) is<br>v_temp varchar2(32767);<br>begin <br> v_temp:='insert into test(a,b) values("时间","力热网");';<br>execute immediate v_temp;<br> COMMIT;<br>EXCEPTION<br> WHEN DUP_VAL_ON_INDEX THEN<br> ROLLBACK;<br> when others then<br> ROLLBACK;<br>end ExecInsert;