VBA: Run-time error 3001 Arguments Are Of The Wrong Type… when setting ADODB.Command object members

This forum post saved my day.I was trying to run Oracle stored procedure with output parameters from Excel VBA with the following piece of code: Dim cmd As ObjectDim resultSet As ObjectSet cmd = CreateObject(“ADODB.Command”)With cmd .CommandText = “PK_AUTH.LOGON” .NamedParameters = True .Parameters.Append .CreateParameter(“login”, adVarChar, adParamInput, 50, login_) .Parameters.Append .CreateParameter(“pass”, adVarChar, adParamInput, 50, pass_) .Parameters.Append […]