Applies to Apex 4.2
When writing page processes which perform PL/SQL actions, i'd like to reference the process name within the PL/SQL block for logging purposes.
Presently i'm having to cut© the process name into the pl/sql each time and it's very easy to get it wrong.
For example, I'd like to do something such as:
myDebug.Write(:APP_PAGE_ID, :APP_USER, :PAGE_PROCESS_NAME, 'some logging here');
This would allow me to put standard lines of logging at the top of each process without the need to worry about getting the name correct.
Assuming that there's no substitution string, is it something accessible from an apex view perhaps ?
Well there is this, apex_application_processes, but I'm not sure that will help you.
If you're talking about calling myDebug.Write() many times within the process then I have two points
1) why not use a local variable to store process name?
2) you should be utilising pl/sql packages instead of putting large amounts of code within APEX
in which case you should also consider using