HCL Domino - ExecProcedure Method - Need a Domino Consultant? Call NotesMail +1 212-599-2048

HCLSoftware Business Partner Domino Consulting Services CRUCIAL Notes Tools +1 212-599-2048	Domino Consulting Services CRUCIAL Notes Tools Domino administration Notes development	Chat now
.

Need a Domino Consultant? Call NotesMail +1 212-599-2048 - HCLSoftware Business Partner

LOTUS CONNECTORS

ExecProcedure Method
Example

Executes a stored SQL procedure.

Defined in

ODBCResultSet

Syntax

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

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

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.

Return value

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

Example

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Feedback on Help or Usability?

Help on Help

All Help Contents