La funcion es la siguiente:
Dim ObjCommand As New ADODB.Command
Dim rsD As New ADODB.Recordset
Dim msSQL As String
ObjCommand.ActiveConnection = gstrCadenaConexion
ObjCommand.CommandText = "spTraeInstituciones"
ObjCommand.CommandType = adCmdStoredProc
ObjCommand.Parameters.Append ObjCommand.CreateParameter
("CodDANE_p", adBSTR, adParamInput, 15, CodDANE)
ObjCommand.Parameters.Append ObjCommand.CreateParameter
("CodJorna_p", adInteger, adParamInput, , CodJorna)
ObjCommand.Parameters.Append ObjCommand.CreateParameter
("Datos_p", adIUnknown, adParamOutput, , rsD)
ObjCommand.Execute
Set ObjCommand = Nothing
Set TraeInstitucion = rsD
.....
¿Cómo hago para tomar el cursor que envía el store
procedure?
Gracias de antemano