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.
