Returning parameters from an Oracle Procedure (ado & vb6).



Hello,

I have an Oracle procedure defined as (this works in SQLPlus):
procedure fleet_prc( incriteria IN varchar2,
eng OUT varchar2,
engdt OUT varchar2,
trn OUT varchar2,
trndt OUT varchar2)


I've tried to access it via
Set cmdStoredProc = New ADODB.Command
Set cmdStoredProc.ActiveConnection = cnnOracle
cmdStoredProc.CommandType = adCmdText
strCommandText = "{call prc.fleet_prc(?,?,?,?,?)}"


cmdStoredProc.CommandText = strCommandText
cmdStoredProc.Parameters.Append
cmdStoredProc.CreateParameter("incriteria", adVarChar, adParamInput,
17, strVIN)
cmdStoredProc.Parameters.Append
cmdStoredProc.CreateParameter("eng", adVarChar, adParamOutput, 255)
cmdStoredProc.Parameters.Append
cmdStoredProc.CreateParameter("engdt", adVarChar, adParamOutput, 255)
cmdStoredProc.Parameters.Append
cmdStoredProc.CreateParameter("trn", adVarChar, adParamOutput, 255)
cmdStoredProc.Parameters.Append
cmdStoredProc.CreateParameter("trndt", adVarChar, adParamOutput, 255)


Set rsEmp = New ADODB.Recordset
Set rsEmp = cmdStoredProc.Execute()


However, at this point I receive the error:
[Microsoft][ODBC driver for Oracle]Syntax error or access


my connection string is:
Provider=MSDASQL.1;Extended
Properties="DRIVER={Microsoft ODBC for
Oracle};UID=****;PWD=***;SERVER=***;"


Any and all help would be appreciated!!!!


Thanks,


David

.