Procedimientos almacenados

[TioBeni]

Aqui tienes un ejemplo:
...
Set oCmd = New ADODB.Command
With oCmd
.Parameters.Append oCmd.CreateParameter("NUMBE", adInteger, adParamInput, 4, NumOp)
.Parameters.Append oCmd.CreateParameter("RESUL", adVarChar, adParamOutput, 254, Resul)
.CommandText = "NomPackage.NomProcStored"
.CommandType = adCmdStoredProc
.ActiveConnection = gCN 'Objeto connection
.Execute
End With

Resul = oCmd.Parameters(1).Value
...
y a correr!!! :)
Un salu23.