Re: Distributed transactions (two-phase commint) without DB links

It seems to me a case of "You pays your money and you picks your poison."

You have institutional standards (and an institutional body of knowledge) for OCI in applications. As long as the standards don't change and the knowledge isn't lost it looks as if it will work fine for you.

In other institutions, where contractors come and go on an annual basis, I would think that DB links are more widely understood and easier to implement and troubleshoot.

The more I dig into the current database that I'm troubleshooting the less I appreciate non-standard, if brilliant, approaches. Remember, long after you're gone, someone is going to have to maintain the work that you did.

--
http://www.freelists.org/webpage/oracle-l