ADO and Oracle Stored Procedure

[Gsurfdude]

Hello,

I have an Access DB with ODBC linked tables to an Oracle DB. When trying to
execute a stored procedure in Oracle, I get the error:
ORA-06550 Line1, Column 91
PLS-00103: Encountered the symbol ">" When expecting one of these (-+ case
mode not null others <an identifier>
<a double-quoted delimited-identifier>

The VBA code:
glbCNN = ("Driver={Microsoft ODBC for
Oracle};Server=RCMR_TEST;Uid=fred_rcv;Pwd=fred_rcv;")
CN.Open glbCNN

Set objCmd = New ADODB.Command

objCmd.CommandText = "SP_ROUTE_EXTRACT"
objCmd.CommandType = adCmdStoredProc
objCmd.ActiveConnection = CN

objCmd.Parameters.Refresh

Set objParam1 = objCmd.CreateParameter("@var_reg_id", adInteger,
adParamInput)
Set objParam2 = objCmd.CreateParameter("@v_rclink", adVarChar,
adParamInput, 10)
Set objParam3 = objCmd.CreateParameter("@Beg_MEASURE", adDouble,
adParamInput)
Set objParam4 = objCmd.CreateParameter("@USER_ID", adVarChar,
adParamInput, 30)
'
objCmd.Prepared = True

objCmd.Parameters.Append objParam1
objCmd.Parameters.Append objParam2
objCmd.Parameters.Append objParam3
objCmd.Parameters.Append objParam4

objCmd(0) = var_reg_id
objCmd(1) = sRCLink
objCmd(2) = dBeg_Measure
objCmd(3) = glbUserID
Set RS = objCmd.Execute("SP_ROUTE_EXTRACT")
CN.Close
Set CN = Nothing

The Oracle DB developer says it works. Hmmm, am I missing something here in
ADO?

Thanks

 

[Stefan Hoffmann]

hi,

I have an Access DB with ODBC linked tables to an Oracle DB. When trying to
execute a stored procedure in Oracle, I get the error:

The VBA code:
glbCNN = ("Driver={Microsoft ODBC for
Oracle};Server=RCMR_TEST;Uid=fred_rcv;Pwd=fred_rcv;")
CN.Open glbCNN

Maybe the driver. I never had problems using the Oracle drivers...

mfG
--> stefan <--