O'Reilly logo

Oracle APEX Cookbook - Second Edition by Marcel Van Der Plas, Michel Van Zoest

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

Debugging an APEX application remotely

When developing an application you may want to see what actually happens on page processing or running some PL/SQL code. Especially PL/SQL code that is stored in the database and called from a page within APEX, is hard to debug. However, Oracle SQL Developer offers a way to debug PL/SQL code that is called from APEX. We will show you how to do that.

Getting ready

Make sure you have the latest version of SQL Developer, which can be found on http://www.oracle.com/technetwork/index.html. And that you have an application with a page that calls a PL/SQL procedure in the database. In this recipe we take the Twitter search from Chapter 1, Creating a Basic APEX Application. We will call the app_search_user procedure. ...

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