Hi,
Situation as follows
- a C++ component with OCI-calls running under the control of COM (w2k)
- component is marked transactional
- the component connects to database1 but wants to update tables in
database2 (through a databaselink).
- Oracle version is 8i on client and server
Initially we received an Oracle error 24777 : Use of non-migratable database
link not allowed.
After reading some documentation we decided to configure Multi Threaded
Server but now the database-server processen are instable.
Doing something like "insert into database2 as select from a table in
database1" hangs up the database-processes.
Is there some thinking-error in our solution?????
How can I make a 'transactional' com-component doing selects and updates in
more then 1 database?
roy
Situation as follows
- a C++ component with OCI-calls running under the control of COM (w2k)
- component is marked transactional
- the component connects to database1 but wants to update tables in
database2 (through a databaselink).
- Oracle version is 8i on client and server
Initially we received an Oracle error 24777 : Use of non-migratable database
link not allowed.
After reading some documentation we decided to configure Multi Threaded
Server but now the database-server processen are instable.
Doing something like "insert into database2 as select from a table in
database1" hangs up the database-processes.
Is there some thinking-error in our solution?????
How can I make a 'transactional' com-component doing selects and updates in
more then 1 database?
roy