Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Access APEX views from other db-user

TobiPApr 1 2015 — edited Apr 21 2015

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

This post has been answered by fac586 on Apr 1 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 19 2015
Added on Apr 1 2015
6 comments
1,971 views