Query WWV_FLOW_ACTIVITY_LOG from within an apex application
431784Apr 28 2010 — edited Apr 29 2010Hi,
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