Databases Reference
In-Depth Information
Figure 6-22.
Debug data gathered programmatically
While it may be more natural to think that a Page Process might be the best place to turn on
programmatic debugging, there is some method to the madness of choosing a Branch instead. No
matter what its sequence number, Page Processes
always
execute after Branches and Computations.
Therefore if you want to capture information about Branches and Computations in your debug output,
you must turn Debug mode on before these items are processed by APEX.
The ability to create a Branch of type Branch to PL/SQL Procedure at process point On Load: Before
Header that actually does not branch anywhere is perfect for our purposes. As long as its sequence
number is lower than any other branch, programmatic debugging will capture all logged messages for
any Branch, Computation or Process that follows it.
