A few weeks ago someone asked me some general questions about the XA/Open interface in Oracle. Oracle has been XA compliant since Oracle 7, but I kinda excused myself from the conversation as that was just about all I knew about it. During that exchange I was reminded that Oracle Database 11gR1 included the DBMS_XA package to allow PL/SQL to make calls to the XA interface. That made me put DBMS_XA on my to-do list.
Fast forward several weeks and I’ve finally had a look at it. You can see an example of it being used here.
Off the top of my head I can’t think of any situations I’ve encountered that lend themselves to this, but it’s always good to know a little about these things just in case. 🙂