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!

Query WWV_FLOW_ACTIVITY_LOG from within an apex application

431784Apr 28 2010 — edited Apr 29 2010
Hi,

I want to setup a few reports in an application displaying the usage of/activity within that same application.

This involves the view WWV_FLOW_ACTIVITY_LOG but I would like to avoid having to prefix the view with the version specific FLOWS_xxxxxx schema name.

Likewise I want to avoid creating a synonym on that same view.

Such actions will cause the activity reports to fail when upgrading or new installing the next apex version(which hopefully will be out soon I hope :o)).

I was hoping to find an APP_xxxxx constant holding the FLOWS_xxxxxx schema name, but I may have overlooked something.

Any ideas?

Best regards,

Jesper
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 27 2010
Added on Apr 28 2010
2 comments
1,126 views