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