Using the Run Procedure window

When you click on Run from the Database Explorer, you will be shown then Run Procedure window

Enter Values for your Parameters

• you can enter values in the IN and INOUT parameters
• the text will turn red if you enter an invalid value (character value to long, or numeric value not numeric).
• you can click on Set parms to default values. This will set
  • all character parameters to a zero-length string,
  • numeric parameters to 0
  • date/time/timestamp parameters to the current date/time/timestamp.
• you can specify that a parameter is NULL by entering (null) or null
• in the unlikely event that you want to enter the string “null”, and for this not to be interpreted as a NULL, enter null followed by a space
• you can specify a hex value in the format of x'313233'

Running the Procedure

• run the procedure by clicking on RUN.
• if the procedure returns a result-set, it will be displayed.
• if the procedure returns multiple result-sets, these will be displayed on either the same or separate windows, depending on the setting of display multiple result-sets in same window.

Sybase

There are sometimes problems running Procedures with old versions of Sybase and/or the Sybase ODBC Driver. This is described at trouble running Stored Procedures with Sybase.