To edit an input parameter value for a stored procedure
- From the SP Test tool, click a stored procedure on the tree view.
- On the
Parms tab, right-click the
Value column corresponding to the parameter whose value you want to edit, then click
Edit value.
- In the Edit Entry Values editor, type the value of the parameter.
- Click
OK.
- Tab to another column to ensure that the value is saved properly.
Note:
- To view or enter the value in hexadecimal, check
Display value in hexadecimal.
- Numeric parameter values must be valid for the stored procedure to execute properly.
- You can also specify a value by entering it directly into the
Value column or by specifying a side file or special register.
- Values typed directly into the
Value field or into the
Edit Entry Value editor are limited to the length of the parameter.