Prepared-to-Commit from OCI
Date: 1995/12/20
Message-ID: <4b901t$67u_at_news.rz.uni-passau.de>#1/1
Dear OCI-experts,
i have to integrate Oracle in a heterogenous DB-environment. Please look at
the following situation-example for further explanations:
At global level i have a Transaction (TA):
Begin-TA
('modify' is a function which processes any modifications on the databases.)
In case of Oracle the whole interface should be implemented with OCI.
For all OCI-Routines i can reach an error-number if anything fails.
Now look at the following case: The last modify for oracle_1 (++) indicates
no error at time (++), but i can only commit the oracle_1-TA
at time (*), because an atomic global commit is required!
Now my question: Can i get somehow a 'Prepared-to-commit' from OCI at time (*)
(perhaps a long time after the last OCI-function for oracle_1-TA has
succeded), so that i can either call 'ocom' or 'orol' for the oracle_1-TA?
Ciao,
KLaus Berndl
Received on Wed Dec 20 1995 - 00:00:00 CET
modify(oracle_1, "update table_1 set...")
modify(informix_1, "update table_3 set...")
modify(oracle_1, "update table_2 set...") (++)
modify(informix_1, "update table_4 set...")
modify(informix_1, "delete from table_4...")
Commit-TA (*)
(Reading the 'return-code'-field of the 'lda'-structure, which belongs to the
oracle_1-connection, at time (*) was my first idea.)