Devart Forums

Hello,
I use ODAC 5.70 / Oracle 10.1.0.5 G with C++ Builder 6.0. I have a multithreaded application which fails from time to time on simple select statements (they return 10 rows). The error I receive is always "out of memory".
In my application I use a different TOraSession and TOraQuery for each thread.
With the previous old BDE from Borland everything were fine. Could it be that the "Direct Connect" option raises this problem ? Should I do something specific to my multithreaded application ?
Thanks a lot

Possibly this problem is caused by memory leaks in your program. To detect memory leaks you can use a third party memory manager such as FastMM4 or special tools (AQTime, MemProof).

I'm afraid I have no memory leak. The same application works fine with the borland BDE. Here I get an exception when executing a Select statement, in the exception message I have "Out of memory". If I had memory leaks then my app would consumes more and more memory and I will able to see it in the TaskManager application. A memory leak would not throw an exception.
In the meanwhile I've tried not to use the direct connect option, so now I use the Oracle client but I still have this "out of memory" for different Sql statements which have been tested and do not fetch a huge amount of rows.
What is strange is that only Select statements fails, never an Insert or Update.
In the list of exception error messages that can be returned for a Select, do you have this "out of memory" message ?
Best Regards

The list of ODAC error messages doesn't contain the "Out of memory" message. We cannot reproduce this problem. Please send to ODAC support address complete sample that demonstrates the problem and include script to create server objects.