Dear forum members,
I try to parallelize operations by using several threads in my application. The first thread stream data to the local file system, a second thread decompress the data downloaded by the first thread and a third thread uploads the decompressed data back to the database.
Every thread is working properly if running solely. Also thread one and two operates together as expected. But if thread 3 is running a exception is raised by the Oracle database: ORA-03127. It seems that multiple simultaneous operations not allowed. Is there a way to get this approach working? No matter if this is a limitation of the Oracle database or the dbexpoda driver. I use Oracle 10g (OCI bridge) and dbexpoda release 2.50.5.0. The application is developed under Delphi 6.
Thanks in advance for your help.
Best regards,
Carsten
Oracle 10g: Multiple simultaneous operations possible?
I want to give a short response to close this thread. After reviewing the source code once again I noticed that an (DML) update statement was executed through a TSQLConnection component from a different thread and not over the one of the own thread. So Plash was right (I never had any doubts!).
Thank you very much for your help again!
Best regards, CG
Thank you very much for your help again!
Best regards, CG