Run Stored Procedure window

Start the Run Stored Procedure window from the Database Explorer. Select a procedure then click on Tools > Run Stored Procedure or click on the Run icon.

The parameters for the Stored Procedure will be displayed. These will be of type IN, OUT or INOUT.

• 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 and

  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 parameter value
• 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

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.
• you will then be returned to the Run Procedure window. If the procedure has returned any OUT or INOUT parameters, you will be shown these values.

You might have trouble running Stored Procedures with Sybase.

Copy to SQL Window

This copies the SQL for running your Stored Procedure to the SQL window. This is useful if you wish to run your procedure from the SQL window, or in batch mode.

For more information on running stored procedures from the SQL window, see Running a Stored Procedure.

Running Oracle Packages

Oracle Stored Procedures can be contained inside packages. The Run Stored Procedure window cannot run such procedures (this is because AQT cannot get the information on the parameters for these procedures). Instead you must run these procedures "manually" from the SQL window. This is discussed in Running a Stored Procedure.

Return Values containing x'00' values

If your OUT and INOUT parameters contain x'00 (binary zero) characters, then the data will not display. To circumvent this problem, select Options > Display Limits > Display x'00' characters as spaces.