The Param phrase identifies a run-time parameter to be passed to the stored procedure. A parameter has the following syntax:

[([INPUT|OUTPUT|INPUT OUTPUT][PARAM parameter-name =]expression, ...     
    [INPUT|OUTPUT|INPUT OUTPUT][PARAM parameter-name =]expression )]

An expression is a constant, field name, variable name, or expression. INPUT is the default. OUTPUT and INPUT-OUTPUT parameters must be record fields or program variables.

If you run send-sql-statement for an Oracle-based data source, you must pass a single character expression parameter containing the SQL statement you want the data source to execute.

Note: The Oracle DataServer only supports one SQL statement with the send-sql-statement option.

If you do not specify parameter-name (the name of a keyword parameter defined by the stored procedure), you must supply all of the parameters in correct order. If you do specify parameter-name, you must precede your assignment statement with the keyword PARAM. If you do not supply a required parameter, and no default is specified in the stored procedure, you receive a run-time error.