Page 1 of 1

ODAC & DLL

Posted: Thu 26 Apr 2012 09:50
by Muxys
Hi there,

ODAC is buggin' when using DLL's to run queries?! (Oracle 10&11)

Here's a simple project to demonstrate...
https://www.br-e-a-s-t.org/uploads/prjTestODAC.zip
I've lost days, and weeks trying to build an old project that was working before, unsuccessfully.

I have tried under W7, XP, old versions of ODAC (7, 8) and old versions of Delphi (2K9, SE, XE2)

Just one of the two queries works perfectly, as much time I want to run it, but the other query works... Only once! When it is ran, no other query can be run afterwards without having a great exception failure...

For months I've been trying to make that work and with last upgrade before my subscription ended (8.1.4) it was still not working.

I cannot re-conduct my subscription until this issue is solved...

Posted: Thu 26 Apr 2012 12:46
by AlexP
hello,

In the archive you specified, there are no scripts for creating and filling of tables, please send them to alexp*devart*com.
We have checked the workability of the application on our tables and found no errors, the application works and the queries run any number of times. If the problem is that when running a "long" query, you need to run several more queries in parallel, you should move the queries executing to separate threads.