I was going through an article - "Procedure vs Package" - where I found this statement:
break the dependency chain (no cascading invalidations when you
install a new package body -- if you have procedures that call
procedures -- compiling one will invalidate your database)
I tried it but don't see any invalid objects. Below is the code I am using on Oracle 12C.
create or replace procedure B
as
begin
null;
End;
create or replace procedure A
as
begin
B;
end;
alter procedure B compile;
select object_type, object_name, status
from user_objects
Where Status = 'INVALID'
order by object_type, object_name
Am I missing something or things have changed in Oracle 12c?