Stored Procedure & Function Debugger

Previous  Top  Next

Starting the Stored Procedure & Function Debugger

You can start debugging a routine by using the Debug Routine button in the toolbar, after selecting a routine from the database tree view, or by using the context menu in the database tree view.


If the Stored Procedure or Stored Function has input parameters, the Edit Stored Procedure/Function Parameters dialog will be displayed.


Enter values for the parameters


The NULL columns signals a parameter to be NULL, while the Default columns tells the parameter to be the default, if it has a default assigned.


Click OK to continue to the debugger main window after editing the parameter values.


If you start the debugger multiple times for the same routine, there's a Parameter History available. You can click the line in the history to select the same values again.


If there are no input parameters, the dialog will be skipped and we go straight to the debugger main window.


For more information on the debugging process, see Debugger Overview.