Stored Procedure Specifications - Settings (ODBC and Oracle)

Use the Stored Procedure Specifications - Settings window to specify or change the parameters of the stored procedure specification that you are defining or editing. A stored procedure specification defines the inputs, outputs, and procedure name of a particular stored procedure file. Once defined, you associate a stored procedure specification with a Stored Procedure part and the input fields and output fields are added as attributes of the Stored Procedure part's public interface.

Fields

•

Name

•	Description

•	Procedure name

•	Input/Output variables

Pop-up menu

•	Pop-up menu

Push buttons

Select OK to update the part and close the window.

Select Cancel to close the window without updating the part.

Tasks

•	Accessing database data

Procedure name

ODBC and ORACLE can query the database to retrieve procedure names. Select the procedure name from this combo box.

If you use ORACLE and you have defined stored procedures in packages, then those stored procedure names will not appear in the combo box. You can type the procedure name into this field as <package>.procedure. Replace package with the package name and procedure with the procedure name.

Input/Ouput variables

Define the input/output data fields for the stored procedure using Input/Ouput variables.

The pop-up menu for Input/Ouput variables contains choices for adding data fields.

For ODBC and ORACLE, the input and output variable fields are combined into one field called input/output variables. These database managers can automatically query the database for parameter shapes and display the parameters in the list. Select Get schema from the field's pop-up menu to query the database for parameters.

For native ORACLE support, fields with the nulls allowed attribute set are assumed to be used for output only.