Re: Oracle 92 ODBC/ VB6/ Stored procedure

ushajairam_at_yahoo.com (Usha) wrote in message news:<cd6b676.0302141048.7efba0db_at_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...

First off, can you execute this particular stored procedure via SQL*Plus? If I understand you correctly, you're migrating both the client and the database to 9.2, so it's possible that the stored procedure no longer works correctly. Particularly since your other statements are working via ODBC, it seems unlikely that the driver would fail on this particular statement.

If you can turn on ODBC tracing when you execute this procedure, that may also help to isolate the cause of the problem. If you can get the full Oracle error message that's coming back, that would be most helpful.

Justin Cave

>
> 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 - 18:52:12 CST