My project team and are in the midst of converting our current Oracle 8i database (8.1.7.3) to 9i (9.2.0.5.0) and have come across an issue when trying to retieve data from the database using stored procedures. Using ADO we attempt to retieve a result set with the lock type set to adLockBatchOptimistic and are recieving a catastropic error. We have tested creating dynamic sql statements and retrieve result sets that way, and there is no problem. The issue seems to be when we set the ado recordset locktype to adlockbatchoptimistic. We have changed the locktype to adLockOptimistic and have been successful. This is not a acceptable solution though as we have many components which use the adLockBatchOptimistic locktype. Our data provider is the Oracle ODBC driver. Anybody know of any issues with this driver and adlockbatchoptimistic? Anybody have any ideas? Thanks in advance

Phil

You might want to try a different technology (OLE DB, etc.), and see if the problem abates. (This would verify whether the problem lies within the particular wrapper.)