Oracle automatic precheck of stored object replacement - Stack Overflow

admin2025-04-06  0

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
转载请注明原文地址:http://conceptsofalgorithm.com/Algorithm/1743952794a225392.html

最新回复(0)