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