Setting the Stored Procedure Variable dialog box options

The purpose of this dialog box is to add or edit stored procedure parameters.

To set the dialog box options:

1. The name of the variable you are editing appears in the Name text box.
2. Select a Direction from the pop-up menu.

   A stored procedure might have input values, output values, or both input and output values.

3. Select an SQL type from the pop-up menu.
4. Enter a return variable.
5. Enter a runtime value.
6. Enter a test value.

Related topics

• Setting the ColdFusion Stored Procedure dialog box options
• Using stored procedures to modify databases (ColdFusion)