6.14 Develop ORDS App with XA

Configure an Oracle Database application, that you have built using Oracle APEX and Oracle REST Data Services (ORDS), as a transaction initiator or participant in an XA transaction with MicroTx.

A database application is an Oracle APEX and ORDS application which uses an Oracle Database. You can run the database application in a managed APEX service in Oracle Cloud Infrastructure, an Oracle RAD stack deployed in a Kubernetes cluster, or a Oracle RAD stack deployed within a VM or a physical host. The Oracle RAD stack is an inclusive technology stack based on three core components: Oracle REST Data Services (ORDS), Oracle APEX, and Oracle Database.

• Prerequisites
  
• Run MicroTx PL/SQL Library
  The MicroTx PL/SQL library for XA provides a set of functions and stored procedures for an Oracle Database application to participate in an XA transaction that is coordinated by MicroTx.
• Configure PL/SQL Library Properties for ORDS Apps
  Provide configuration information for the MicroTx PL/SQL library properties for ORDS application. The property values that you must provide would vary depending on whether the application only participates in the transaction or initiates it.
• Privileges
  Set the privileges required to run the MicroTx PL/SQL library.
• Configure ORDS App as Transaction Initiator
  
• Configure ORDS App as Transaction Participant
  
• MicroTx PL/SQL Library Functions
  The MicroTx PL/SQL library provides the following functions to specify the transaction boundaries.