Oracle Apex Practical Note Series 1-oracle Apex Debugging Tips

1. Understanding Oracle Apex URL Syntax

An Oracle Apex URL example looks like this:

http://myhost.mycompany.com/myservice/f?p=1023:1:220883404335693447

Divided into several parts

• Myhost.mycompany.com is the server URL
• MyService is a database service
• f?p= is the Apex URL prefix section
• 1023 is Application ID
• 1 is the page ID
• 220883404335693447 is session ID
  

We can use f?p= to access the page and pass parameters, and its syntax is

f?p=app:page:session:request:debug:clearcache:itemnames:itemvalues:printerfriendly

This is related to debugging in the middle part of the 4th colon and the 5th colon, yes to start debug mode, no to turn off debug mode.

So, the previous example can use the following URL to open debug

Http://myhost.mycompany.com/myservice/f?p=1023:1:220883404335693447::YES

2. Another way to turn on debug

When we launch an APEX application, there will be a toolbar under the browser, a debug button on the right side of the view debug, and click it to switch to debug mode, and the button is displayed as no debug (for example). However, there is a drawback of this method will clear the parameters, but the URL method will not lose parameters, so I recommend the URL method.

2. Observe the debug record

When debug mode is turned on, the desired operation is performed, and then the view debug is used to see the operation record.

3. Add the customized information

In addition to some of the default log information, we can also add our customized information, such as printing some parameter values of the halfway step. This can take advantage of some PL/SQL functions from the apex, which are:

Apex_application.g_print_success_message: = ' message '; Wwv_flow.debug (' message '); Apex_debug.message (' message ');

1 of the effects are: when the page loads there will be an information popup display

The effect of 2,3 is to see the output in process in view Debug.

Oracle Apex Practical Note Series 1-oracle Apex Debugging Tips