ExecProcedure (ODBCResultSet - LotusScript)
Executes a stored SQL procedure.
Defined in
Parameters
procedureName$
String. The name of the SQL procedure you want to execute.
arg1 ... arg30
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.
DB_PARAM_ARRAY, argArray
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.
Syntax
status = odbcResultSet .ExecProcedure( procedureName$ , DB_PARAM_ARRAY, argArray )
Return Value
Varies, depending on the definition of the stored procedure, which may return output arguments, a result set, or an execution status.