create or replace procedure test(strsql in VARCHAR2, a in integer, b in integer, out_msg out varchar2) is begin EXECUTE IMMEDIATE strsql; out_msg:='1'; return out_msg; exception WHEN OTHERS THEN BEGIN out_msg:='0'; return out_msg;end test;这样可以返回值判断存储过程是否执行成功。
a in integer,
b in integer,
out_msg out varchar2) is
begin
EXECUTE IMMEDIATE strsql;
out_msg:='1';
return out_msg;
exception
WHEN OTHERS THEN BEGIN
out_msg:='0';
return out_msg;end test;这样可以返回值判断存储过程是否执行成功。
或dbms_sql执行动态sql