Preparing to debug

When deploying a stored procedure for debug, you must enable debugging and set the session manager preferences.

About this task

When deploying SQL stored procedures, you enable debug by selecting the Enable debugging check box in the Routine Options page of the Deploy Routines wizard.

When deploying Java stored procedures, you enable debug by entering -g in the Compile options field in the Routine Options page of the Deploy Routines wizard.

Before you can debug SQL or Java stored procedures, you must set the session manager preferences in the stored procedure debug preferences. For information about this, see the related topic.


Feedback