Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Oracle 92 ODBC/ VB6/ Stored procedure

Oracle 92 ODBC/ VB6/ Stored procedure

From: Usha <ushajairam_at_yahoo.com>
Date: 14 Feb 2003 10:48:58 -0800
Message-ID: <cd6b676.0302141048.7efba0db@posting.google.com>


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...



With rdoQryList
    Set .ActiveConnection = grdoConnODBC

.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.
Received on Fri Feb 14 2003 - 12:48:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US