Re: Oracle 92 ODBC/ VB6/ Stored procedure

Thanks. Yes, the procedure executes in SQL*Plus. ODBC trace did not yeild anything helpful. All calls to execute stored procedure using Oracle 9.2 ODBC driver fails. One thing I forgot to mention is that in addition to migrating to Oracle 9.2, we are also moving from NT to XP. I get the following error only when I use 9.2 ODBC driver:

"Error Number: 40041
Oracle Error: Object Collection: Couldn't find item indicated by text"

jocave_at_yahoo.com (Justin Cave) wrote in message news:<233b7a65.0302141652.4e83dc4_at_posting.google.com>...
> 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 Wed Feb 19 2003 - 12:37:42 CST