Devart Forums

The UnPrepare method has different behavior depending on the Oracle database version. When I was using Oracle8i there was not any need of verifying if the data set was prepared or not before calling the UnPrepare method.
Now, using Oracle 9.0.2.x, it is required to check if the data set is "prepared" before calling the UnPrepare method. Is there any recommended sequence among methods calls like Close, Prepare, parameter definition, parameter setting, and others, that works for any version of the Oracle database ?

Jayme.

Describe your problem more detailed. Also specify your full ODAC version.
There is no difference with calling UnPrepare method using ORACLE 9i or 8i server. ODAC made all necessary checks internally and you can call this method whenever you want. If it is possible send us small demo project that demonstrates your problem to ODAC support e-mail address.

Dear Alex,

I have made a simple application using C+Builder 6.0 and check it against Oracle 8i, 9iR2 and 10gR2. I could not reproduce the same error I have got in the complex application.
As the application itself has a lot of other classes with so many compiler warnings that I might suppose that the error do not comes from ODAC components. I will try the simple application in a computer without the Oracle client, which is when I have got the reported errors and then I will post the results to this forum.

Thank you very much.

Jayme.