Oracle | DBMS

Oracle DBMS_SAGA Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose SAGA Microservices architecture support subprograms (also known as Epic).

AUTHID CURRENT_USER

Constants

Name	Data Type	Value
OPCODEs
CMT_SAGA	NUMBER	2
ABRT_SAGA	NUMBER	4
REQUEST	NUMBER	7
RESPONSE	NUMBER	8
CMT_FAIL	NUMBER	9
ABRT_FAIL	NUMBER	10

Data Types subtype saga_id_t IS RAW(16); type saga_payload_arr IS VARRAY(256) OF SYS.AQ$_JMS_TEXT_MESSAGE; /* for user defined AfterSaga callback */ subtype saga_status IS VARCHAR2(20);

Dependencies

AQ$_DESCRIPTOR	DBMS_SAGA_ADM	DBMS_STNDARD
AQ$_JMS_TEXT_MESSAGE	DBMS_SAGA_ADM_SYS	DBMS_SYSTEM
AQ$_REG_INFO	DBMS_SAGA_LIB	DBMS_UTILITY
DBMS_AQ	DBMS_SAGA_SYS

Documented Yes: Packages and Types Reference

Exceptions

Error Code	Reason
ORA-45493	ROLLINGUNSUPPORTED

First Available 23ai

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, NONE);

Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE and SAGA_PARTICIPANT_ROLE roles.

Source {ORACLE_HOME}/rdbms/admin/dbmssaga.sql
{ORACLE_HOME}/rdbms/admin/prvtsaga.plb

Subprograms

AFTER_SAGA	GET_SAGA_RECIPIENT	SEND_REQUEST
BEGIN_SAGA	GET_SAGA_SENDER	SET_INCOMPLETE
COMMIT_SAGA	GET_SAGA_TIMEOUT	SET_SAGA_COORDINATOR
FORGET_SAGA	GET_SAGA_VERSION	SET_SAGA_ID
GET_SAGA_BEGIN_TIME	IS_INCOMPLETE	SET_SAGA_OPCODE
GET_SAGA_COORDINATOR	LEAVE_SAGA	SET_SAGA_RECIPIENT
GET_SAGA_ID	NOTIFY_CALLBACK_PARTICIPANT	SET_SAGA_SENDER
GET_SAGA_OPCODE	ROLLBACK_SAGA	SET_SAGA_VERSION

AFTER_SAGA (new 23ai)

Undocumented dbms_saga.after_saga(saga_id IN saga_id_t);

TBD

BEGIN_SAGA (new 23ai)

Undocumented dbms_saga.begin_saga( initiator_name IN VARCHAR2, timeout IN NUMBER DEFAULT 0, version IN NUMBER DEFAULT 1) RETURN saga_id_t;

TBD

COMMIT_SAGA (new 23ai)

Undocumented dbms_saga.commit_saga( saga_participant IN VARCHAR2, saga_id IN saga_id_t, force IN BOOLEAN DEFAULT FALSE);

TBD

FORGET_SAGA (new 23ai)

Undocumented dbms_saga.forget_saga(saga_id IN saga_id_t);

TBD

GET_SAGA_BEGIN_TIME (new 23ai)

Undocumented dbms_saga.get_saga_begin_time(message IN OUT sys.aq$_jms_text_message) RETURN TIMESTAMP WITH TIME ZONE;

TBD

GET_SAGA_COORDINATOR (new 23ai)

Undocumented dbms_saga.get_saga_coordinator(message IN OUT sys.aq$_jms_text_message) RETURN VARCHAR2;

TBD

GET_SAGA_ID (new 23ai)

Undocumented

Overload 1 dbms_saga.get_saga_id RETURN saga_id_t;

TBD

Overload 2 dbms_saga.get_saga_id(message IN OUT sys.aq$_jms_text_message) RETURN RAW;

TBD

GET_SAGA_OPCODE (new 23ai)

Undocumented dbms_saga.get_saga_opcode(message IN OUT sys.aq$_jms_text_message) RETURN NUMBER;

TBD

GET_SAGA_RECIPIENT (new 23ai)

Undocumented dbms_saga.get_saga_recipient(message IN OUT sys.aq$_jms_text_message) RETURN VARCHAR2;

TBD

GET_SAGA_SENDER (new 23ai)

Undocumented dbms_saga.get_saga_sender(message IN OUT sys.aq$_jms_text_message) RETURN VARCHAR2;

TBD

GET_SAGA_TIMEOUT (new 23ai)

Undocumented dbms_saga.get_saga_timeout(message IN OUT sys.aq$_jms_text_message) RETURN NUMBER;

TBD

GET_SAGA_VERSION (new 23ai)

Undocumented dbms_saga.get_saga_version(message IN OUT sys.aq$_jms_text_message) RETURN NUMBER;

TBD

IS_INCOMPLETE (new 23ai)

Undocumented dbms_saga.is_incomplete(saga_id IN saga_id_t) RETURN BOOLEAN;

TBD

LEAVE_SAGA (new 23ai)

Undocumented dbms_saga.leave_saga(saga_id IN saga_id_t);

TBD

NOTIFY_CALLBACK_PARTICIPANT (new 23ai)

Undocumented dbms_saga.notify_callback_participant( context IN RAW, reginfo IN sys.aq$_reg_info, descr IN sys.aq$_descriptor, payload IN RAW, payloadl IN NUMBER);

TBD

ROLLBACK_SAGA (new 23ai)

Undocumented dbms_saga.rollback_saga( saga_participant IN VARCHAR2, saga_id IN saga_id_t, force IN BOOLEAN DEFAULT FALSE);

TBD

SEND_REQUEST (new 23ai)

Undocumented dbms_saga.send_request( saga_id IN saga_id_t, recipient IN VARCHAR2, payload IN JSON DEFAULT NULL, saga_version IN NUMBER DEFAULT 1, saga_spare IN VARCHAR2 DEFAULT NULL);

TBD

SET_INCOMPLETE (new 23ai)

Undocumented dbms_saga.set_incomplete(saga_id IN saga_id_t);

TBD

SET_SAGA_COORDINATOR (new 23ai)

Undocumented dbms_saga.set_saga_coordinator( message IN OUT sys.aq$_jms_text_message, saga_coordinator IN VARCHAR2, canonicalize IN BOOLEAN DEFAULT TRUE);

TBD

SET_SAGA_ID (new 23ai)

Undocumented

Overload 1 dbms_saga.set_saga_id(saga_id IN saga_id_t);

TBD

Overload 2 dbms_saga.set_saga_id( message IN OUT sys.aq$_jms_text_message, saga_id IN RAW);

TBD

SET_SAGA_OPCODE (new 23ai)

Undocumented dbms_saga.set_saga_opcode( message IN OUT sys.aq$_jms_text_message, saga_id IN saga_id_t, opcode IN NUMBER);

TBD

SET_SAGA_RECIPIENT (new 23ai)

Undocumented dbms_saga.set_saga_recipient( message IN OUT sys.aq$_jms_text_message, recipient IN VARCHAR2, canonicalize IN BOOLEAN DEFAULT TRUE);

TBD

SET_SAGA_SENDER (new 23ai)

Undocumented dbms_saga.set_saga_sender( message IN OUT sys.aq$_jms_text_message, sender IN VARCHAR2, canonicalize IN BOOLEAN DEFAULT TRUE);

TBD

SET_SAGA_VERSION (new 23ai)

Undocumented dbms_saga.set_saga_version( message IN OUT sys.aq$_jms_text_message, saga_version IN NUMBER);

TBD