Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Oracle 92 ODBC/ VB6/ Stored procedure
Hello all,
I have a VB6 app running against an Oracle v8.0.6 database and am in the process of migrating to Oracle v9.2. The app uses RDO/Oracle ODBC driver to connect to the database. Problem is, the following code (to execute a stored procedure) that was working with an Oracle 8.0.6 ODBC driver now fails to work with Oracle 9.2 ODBC driver. Interestingly, all other SQLs work without any problem. Any ideas...
Code segment to execute stored procedure...
Set .ActiveConnection = grdoConnODBCReceived on Fri Feb 14 2003 - 12:48:58 CST
.SQL = "{call xxxxxxxx (?,?,?)}"
.Prepared = True
.BindThreshold = 10
.QueryTimeout = 0
.rdoParameters(0).Direction = rdParamOutput
.rdoParameters(1).Direction = rdParamInput
.rdoParameters(2).Direction = rdParamInput
.rdoParameters(0).Type = rdTypeNUMERIC
.rdoParameters(1).Type = rdTypeNUMERIC
.rdoParameters(2).Type = rdTypeVARCHAR
.rdoParameters(1).Value = mintxxxxxx
.rdoParameters(2).Value = mstrxxxxxx
.Execute
mintxxxxxx = .rdoParameters(0).Value End With Error... -------- Error Number: 40041 Oracle Error: Object Collection: Couldn't find item indicated by text. ps: The necessary grants and synonyms are in place.