Hi community!
In one large Applikation I would like to evaluate certain function-calls in the report regions. For this I am accessing one of the apex_application...views:
select application_name, page_id, page_name, region_name, source_type, region_source
from apex_application_page_regions
where application_name = 'Our App'
and source_type in ('Interactive Report','Report')
and region_source like '%my_function%'
...which so far works fine.
Now however this report should be executed from another workspace which uses another db-user. And there I dont get any data results.
I tried to add that other schema to the the original workspace, I tried with grants or synonyms - all made no difference.
For further testing, I wrote this view:
create or replace view ourApp_apeximplementierung_v as
select application_name, page_id, page_name, region_name, source_type
from apex_040200.apex_application_page_regions
where application_name = 'Our App'
and source_type in ('Interactive Report','Report')
and region_source like '%my_function%'
union
select 'application_name', 9999999, 'page_name', 'region_name', 'source_type'
from dual;
The last "dual"-row very well gets displayed in the other schema!
Maybe this has something to do with golabl temporary tables? Because when I create a table from that query, those datas can be recalled.
But the data should be dynamically up-to-date, and I dont want to perform the recreation of the table, every time an APEX-region gets updated.
I took a look at the create script for APEX_040200.APEX_APPLICATION_PAGE_REGIONS. (What is this "APEX_040200." syntax anyway? Is it some kind of sub-schema?) The table wwv_flow_page_plugs inside that script I cant access from the outside. (Would be nice to be able to update APEX-regions via DML ).
So, any help and hints in this dilemma are welcome,
best regards, so long,
tobi