Hi,
I was trying to compile a package in a schema on ADB 23ai where I currently have an APEX instance.
I granted SELECT ANY DICTIONARY privilege to the schema, but for some reason it throws out the following error:
PLS-00201: identifier 'DBA_PROCEDURES' must be declared
Here is a short version of the problem returning the same error:
create or replace procedure test as
x dba_procedures%rowtype;
begin
select *
into x
from dba_procedures
where rownum <=1;
dbms_output.put_line(x.owner);
end;
Error at line 2: PLS-00201: identifier 'DBA_PROCEDURES' must be declared
However if I execute SELECT * FROM DBA_PROCEDURES from APEX SQL Commands in the workspace associated with the schema, it works perfectly.
I am a bit puzzled, is there some special restriction on this type of APEX instances?
Thanks
Flavio