O'Reilly logo

Oracle APEX Best Practices by Learco Brizzi, Iloon Ellen-Wolff, Alex Nuijten

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Remote debugging

The easiest way to illustrate remote debugging is to use Oracle SQL Developer with an application in APEX. The subprogram resides in APEX, and Oracle SQL Developer is used to debug it. This capability is especially useful when an application isn't failing but also isn't producing the results you expect. The following grants are necessary before performing remote debugging:

grant DEBUG CONNECT SESSION to <schema>; 
grant DEBUG on <object> to PUBLIC;
grant DEBUG ANY PROCEDURE to APEX_PUBLIC_USER;

Or ANONYMOUS when using the embedded gateway.

  1. Connect Oracle SQL Developer and import the APEX application.
  2. Set a breakpoint in the code that needs to be debugged.
  3. Compile the procedure for debug.

    Note that running a package in debug mode severely ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required