Stored Procedure & Function Debugger

Top  Previous  Next
Supported for
InterBase, also see InterBase Debugger
Firebird, also see Firebird Debugger
MySQL, also see MySQL Debugger
Oracle, also see Oracle Debugger
PostgreSQL, also see PostgreSQL Debugger

 

Note: Read the database system specific topics for more detailed information on how the debugging process works.

 

Starting the Stored Procedure & Function Debugger

You can reach the debugger by using the Debug button in the editor toolbars, or by using the context menu in the Database Navigator.

 

Reaching the Stored Code Debugger

 

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 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.