1 Reply Latest reply: Jun 2, 2014 7:45 PM by scott.wesley RSS

    Is it possible to reference a page process name within pl/sql block

    Andy Steel

      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&copy 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:

       

      BEGIN

         myDebug.Write(:APP_PAGE_ID, :APP_USER, :PAGE_PROCESS_NAME, 'some logging here');

      END;

       

      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 ?