Executes a stored SQL procedure.

Defined in

ODBCResultSet

Syntax

status = odbcResultSet.ExecProcedure( procedureName$ [, arg1] [, arg2] ... [, arg30] )

or

status = odbcResultSet.ExecProcedure( procedureName$, DB_PARAM_ARRAY, argArray )

Parameters:

procedureName$

String. The name of the SQL procedure you want to execute.

Up to 30 arguments can be passed to a procedure. The arguments can be in any format. An argument can serve as input, output, or both. Argument data types must be consistent with the requirements of the procedure. Separate arguments with commas. Any missing arguments are treated as NULL values. The 30-argument limit is a LotusScript limitation.

To enter more than 30 arguments, you can use the alternate syntax and pass the arguments in an array. In the alternate syntax, the second argument must contain the constant DB_PARAM_ARRAY. The third argument can be an array of any size or type.

Varies, depending on the definition of the stored procedure, which may return output arguments, a result set, or an execution status.

Example

Glossary