Debugging a Stored Procedure

Debug a stored procedure in the Stored Procedure Editor.

From the Debug tab in the Stored Procedure Editor, you can set breakpoints, then debug or run a stored procedure. The Debug tab displays the canonical form of the stored procedure that the database server executes.

  1. In Enterprise Explorer, double-click a stored procedure to open it in the Stored Procedure Editor.
  2. Click Debug.
  3. (Optional) Right-click in the left margin and select Show Line Numbers.
  4. Set breakpoints by double-clicking in the left margin on the appropriate line.
  5. Right-click in the code window and select Debug.
  6. (Optional) Configure the necessary parameters.
  7. Click Yes to open the Database Debug perspective.

    You can continue to debug or run the stored procedure.

Created June 25, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com