Stored Procedure

Use this field to specify the name of the stored procedure to call when this action runs. You can use the drop-down list to select the stored procedure from those available.

If the stored procedure you want to call does not appear on the list, you can use the system filtering capabilities for drop-down lists to locate the stored procedure. An alternate and less highly recommended method would be to increase the drop-down list cap for your system.

To call the stored procedure using an expression, click the button to the left of this field.

The contents of this field must use this syntax:

scalarExpr

where scalarExpr is a literal string or resolves to the name of the stored procedure to call.

When you click OK to return to the Event Actions form, the system "wraps" this content within a METHOD( ) parameter, which yields this final syntax:

METHOD( scalarExpr )

Note: If scalarExpr is a literal value, the system automatically encloses it in double quotation marks when returning it to the Event Actions form. If scalarExpr is an expression, the system does not enclose it in quotation marks.