Execute

Executes the stored procedure in the CommandText Property.

Group: Database Stored Procedure Object

Syntax:

[bOK =]StoredProc.Execute

bOK (Boolean) True or False based on the success of calling the stored procedure regardless of the outcome

Example:

Dim vDict As Variant

Dim vData As Variant

Dim spObj As StoredProc

Set spObj = New StoredProc

spObj.DataSource = "Oracle"

spObj.CommandText = "byroyalty"

spObj.CommandType = dbCmdStoredProc

spObj.Param(1).DataType = dbInteger

spObj.Param(1).Direction = dbParamInput

spObj.Param(1).Value = 100

spObj.Execute

vDict = spObj.Dict

vData = spObj.Data