Debug Procedure Dialog Box

Use the Debug Procedure dialog box to specify parameter values and debug a stored procedure.

Options

Procedures

Select the stored procedure to be debugged.

Parameters

List the parameters defined for the stored procedure.

Data type

Show the data type of the selected parameter.

Direction

Show whether the selected parameter is an input or output parameter.

Value

Specify a value for the selected parameter.

Set to null

Specify a null value for the selected parameter.

Auto roll back

Automatically rolls back all work performed during execution of the procedure.

Execute

Debug the stored procedure using the specified values.