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.
