Devart Forums

Hi,

I have a multi threaded project working for 2 years with many clients and configs without any errors with
Delphi 2007 U3, ODAC 6.25.2.15.

But when I upgraded the ODAC version to 6.90.0.59 I started getting the below errors randomly with diffrerent queries.

OCI_INVALID_HANDLE
ORA-01008: not all variables bound
ORA-01036: illegal variable name/number
ORA-24337: statement handle not prepared

When I switch back to ODAC 6.25.2.15 everything is ok. I'm confused?
I dont use the net option and threadsafety of session is true. Autocommit is set to false.

The program is a multithreaded app with one session created in main thread (and never freed in the lifetime of the exe) and other query, strproc objects created in threads connected using the session in main thread. As I said before the architecture has been stress tested for 2 years and with many clients and worked 7*24.

I want to upgrade to Delphi 2010/XE. But this error prevents me from doing so.

Bora Aydemir

Hello,

Please send me the following information and I will try to reproduce this problem
- the code of the stored procedure where the error occurs;
- the code of the query where the error occurs;
- the parameters of the query and the stored procedure;
- the Delphi code where the error occurs;
- if you can create a small project to demonstrate the problem please send it to me (alexp*devart*com), it'll help us to resolve the problem

Hi

The query's are simple for ex:

SELECT Ci.ForceClose FROM CE_INSTRUMENTS Ci WHERE Ci.InstrumentId = :InstrumentId

InstrumentId is set to 74 .....

This query results with a ORA-24337 with odac 6.90.0.59 (As I said before these query's and project work with 6.25 perfectly. Many threads accept and send data simultaneously and interact with oracle)
The source code is big and detailed. I will try to create a demo project from it.

I have another big project with TOraSession and TQuery's in the same thread (the main thread). It has no problems with 6.90 or 6.25.
So I think it must be about threads an orasession and query being in others threads

Hi Alex,

I sent a sample project to (alexp*devart*com). Please let me know if you dont receive it or have any problems.

Thanks

Bora Aydemir

Any clues or progress?

Hello,

We have reproduced the issue.
We will notify you as soon as we have any results.

Hello

This bug is fixed. This fix will be included in the next ODAC build.

Thanks

I think it will be version 7 build, isn't it?

Hello,

Yes it will be fixed in the next build of the current version.

Any possible date for the next release?

Hello,

The next build will be released approximately in two weeks.

Is this problem fixed in last 6.x version 6.90.0.60 ? This release has release date 13-Aug-10, before this topic was closed. In our aplication we got sometime this error and we use multiple threads. We upgraded from 5.x version, were this problem didnt ocured.

Hello

We fixed some multi-thread issues in the 7.0.0.2 ODAC version. Please try to download the latest version and test your application again. If this issue can be reproduced with the latest version, please contact me here and describe the detailed steps to reproduce this issue.

I cant test 7.0 version as I dont have active subscription(bought upgrade 5-> 6 in 2008, but start using it now after upgrading BDS2006 -> BDS2007). The problem is not reproducable, as it is multi thread releated and ocurs very rarely. I have latest 6 release 6.90.0.60.

Hello

To fix any issue we should reproduce it. Without reproducing it is like to look for a needle in a haystack.

If you don't have active subscription, you can download trial version and check it. If your issue is fixed, you can renew your subscription.