Hi,
I was trying to execute APEX_APP_OBJECT_DEPENDENCY.SCAN on my app 100 (APEX 24.1.5), but I am getting the error below.
I tried on a different app, 102, and it worked, so I must conclude that something specific to app 100 is playing a role here, however without any indication of a specific page or component, it's hard to ascertain where is the problem.
I tried to do the same also on APEX 24.2.11 on OCI where I have basically the same apps, and the situation is identical, app 100 fails, app 102 is OK.
Any ideas as to where to look at ?
Thanks
Flavio
begin
execute immediate q'[alter session set plscope_settings='identifiers:all']';
dbms_utility.compile_schema(user, true);
execute immediate q'[alter session set plscope_settings='identifiers:none']';
APEX_APP_OBJECT_DEPENDENCY.SCAN (100);
end;
ORA-44004: invalid qualified SQL name
ORA-06512: at "APEX_240100.WWV_FLOW_OBJECT_DEPENDENCY_DEV", line 2029
ORA-06512: at "APEX_240100.WWV_FLOW_OBJECT_DEPENDENCY_DEV", line 1903
ORA-06512: at "SYS.DBMS_ASSERT", line 375
ORA-06512: at "SYS.DBMS_ASSERT", line 315
ORA-06512: at "APEX_240100.WWV_FLOW_OBJECT_DEPENDENCY_DEV", line 1456
ORA-06512: at "APEX_240100.WWV_FLOW_OBJECT_DEPENDENCY_DEV", line 1785
ORA-06512: at "APEX_240100.WWV_FLOW_OBJECT_DEPENDENCY_DEV", line 1869
ORA-06512: at "APEX_240100.WWV_FLOW_OBJECT_DEPENDENCY_DEV", line 2005
ORA-06512: at "APEX_240100.WWV_FLOW_OBJECT_DEPENDENCY_API", line 42
ORA-06512: at line 5