To edit an input parameter value for a stored procedure

  1. From the SP Test tool, click a stored procedure on the tree view.
  2. On the Parms tab, right-click the Value column corresponding to the parameter whose value you want to edit, then click Edit value.
  3. In the Edit Entry Values editor, type the value of the parameter.
  4. Click OK.
  5. 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.