oracle执行存储过程出错
create or replace procedure test1
as
sql1 varchar2(4000);
no_result exception;
begin
sql1:='update oa.test set id =1';
execute immediate sql1;
commit;
exception
when no_result then
dbms_output.put_line('error');
end;create or replace procedure