Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Help! Oracle Access and Multithreading
I'm having a problem accessing our Oracle 7 database from two different
threads within a C++ application. What happens is that each thread tries
to
access the database at the same time and the app crashes, giving me the
following message:
ORA-03106: fatal two-task communication protocol error
To my knowledge, Oracle will not allow a single process to have multiple connections to it, so I know that is not the solution.
It was also suggested that I use PL/SQL scripts that reside on the database instead of embedded SQL in my app. Unfortunately that will not work either because the tables being accessed by my app are constantly changing, and PL/SQL scripts would have to be re-written all the time.
For the time being, I have defined a mutex lock that will not allow the two threads to access the database at the same time, but this does not allow the app to achieve the speed that we need. If any of you have encountered similar problems, I would appreciate your suggestions.
Thanks!
-- Matthew K. Smith Acxiom Corporation matsmi_at_acxiom.com 501-336-2434Received on Thu Dec 19 1996 - 00:00:00 CST
![]() |
![]() |