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.