Thanks Tim, I'll look into it.
Regards,
Matthew Watson.
On 18/06/2009, at 3:52 AM, Tim Bunce wrote:
On Wed, Jun 17, 2009 at 01:08:26PM +0800, Matthew Watson wrote:
Hi,
Does DBI ( specifically DBD::Oracle ) have any support for
distributed
transactions (XA). I have a need to share an oracle session between
java
and perl clients, this could be done in Oracle 11g via the DBMS_XA
package,
however it seems like it should be doable in earlier versions via
OCI, is
this support at all?
Short answer: no.
Long answer: drivers are free to add support for XA using driver-
private
methods and attributes. DBD::Oracle supports some mechanisms along
those
lines (see ora_context, ora_extproc, ora_use_proc_connection etc.)
See also the Oracle::OCI module. That should give you access from perl
to just about everything you can do with OCI. It also integrates well
with DBI and DBD::Oracle.
Tim.
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
Please notify the sender immediately by email if you have received this
email by mistake and delete this email from your system. Please note that
any views or opinions presented in this email are solely those of the
author and do not necessarily represent those of the organisation.
Finally, the recipient should check this email and any attachments for
the presence of viruses. The organisation accepts no liability for any
damage caused by any virus transmitted by this email.
