admin管理员组

文章数量:1355068

Is it possible to prohibit changes to the source code of Oracle stored object in case of compile errors?

something like

create or replace procedure test is
 n number;
begin
  select 1 into n from dual;
end test;
/

Procedure created

set magic on

create or replace procedure test is
 n number;
begin
  select 1 into n from dual11111111111;
end test;
/

Procedure will be invalid, its code has not changed

本文标签: Oracle automatic precheck of stored object replacementStack Overflow