SetConnect

RunStoredProcedure

Database::RunStoredProcedure
Description

Run a stored-procedure in the database that is referenced by "Handle".

Use the "Parameters" section to setup parameters which are passed to the stored procedure.

"Input" parameters are used to pass info through to the stored-procedure and "Output" parameters can be used to get information back from the stored-procedure.

Options
Handle
Name of the handle which references the opened database on which the stored-procedure must be executed.
Stored Procedure Name
The name of the stored-procedure.
Parameter Name
The name of the parameter.
Type
The datatype of the parameter.
Size
The size of the parameter.
Value
Only valid for "Input" parameters. The value of the parameter.
Direction
Determines the direction of the parameter: "Input" variables are used to pass info to the stored-procedure. "Output" variables are used to read info from the stored-procedure.
Output Variable
Only valid for "Output" parameters. The name of the variable to which the contents of the parameter will be saved.

Documentation

Release notes