Oracle | DBMS_SAGA

Oracle DBMS_SAGA_ADM 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 Administrative Interface

AUTHID CURRENT_USER

Dependencies

AQ$_DESCRIPTOR	DBMS_SAGA	DBMS_SAGA_SYS
AQ$_JMS_TEXT_MESSAGE	DBMS_SAGA_ADM_SYS	DBMS_SYSTEM
AQ$_REG_INFO	DBMS_SAGA_LIB	PLITBLM
DBMS_AQ

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_ADM_ROLE roles.

Source {ORACLE_HOME}/rdbms/admin/dbmssagaadm.sql
{ORACLE_HOME}/rdbms/admin/prvtsagaadm.plb

Subprograms

ADD_BROKER	DROP_PARTICIPANT
ADD_COORDINATOR	MONITOR_COORDINATOR_QUEUES
ADD_PARTICIPANT	NOTIFY_CALLBACK_COORDINATOR
DROP_BROKER	NOTIFY_CALLBACK_COORDINATOR_NO_AQ
DROP_COORDINATOR	REGISTER_SAGA_CALLBACK

ADD_BROKER (new 23ai)

Undocumented dbms_saga_adm.add_broker( broker_name IN VARCHAR2, broker_schema IN VARCHAR2 DEFAULT sys_context('USERENV', 'CURRENT_USER'), storage_clause IN VARCHAR2 DEFAULT NULL, version IN NUMBER DEFAULT 1);

TBD

ADD_COORDINATOR (new 23ai)

Undocumented dbms_saga_adm.add_coordinator( coordinator_name IN VARCHAR2, coordinator_schema IN VARCHAR2 DEFAULT sys_context('USERENV', 'CURRENT_USER'), storage_clause IN VARCHAR2 DEFAULT NULL, dblink_to_broker IN VARCHAR2 DEFAULT NULL, mailbox_schema IN VARCHAR2, broker_name IN VARCHAR2, dblink_to_coordinator IN VARCHAR2 DEFAULT NULL, version IN NUMBER DEFAULT 1);

TBD

ADD_PARTICIPANT (new 23ai)

Undocumented dbms_saga_adm.add_partitipant( participant_name IN VARCHAR2, participant_schema IN VARCHAR2 DEFAULT sys_context('USERENV', 'CURRENT_USER'), storage_clause IN VARCHAR2 DEFAULT NULL, coordinator_name IN VARCHAR2 DEFAULT NULL, dblink_to_broker IN VARCHAR2 DEFAULT NULL, mailbox_schema IN VARCHAR2, broker_name IN VARCHAR2, callback_schema IN VARCHAR2 DEFAULT sys_context('USERENV', 'CURRENT_USER'), callback_package IN VARCHAR2 DEFAULT NULL, dblink_to_participant IN VARCHAR2 DEFAULT NULL, version IN NUMBER DEFAULT 1);

TBD

DROP_BROKER (new 23ai)

Undocumented dbms_saga_adm.drop_broker(broker_name IN VARCHAR2);

TBD

DROP_COORDINATOR (new 23ai)

Undocumented dbms_saga_adm.drop_coordinator(coordinator_name IN VARCHAR2);

TBD

DROP_PARTICIPANT (new 23ai)

Undocumented dbms_saga_adm.drop_participant(participant_name IN VARCHAR2);

TBD

MONITOR_COORDINATOR_QUEUES (new 23ai)

Undocumented dbms_saga_adm.monitor_callback_coordinator_queues( entity_name_int IN VARCHAR2, partitions IN NUMBER);

TBD

NOTIFY_CALLBACK_COORDINATOR (new 23ai)

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

TBD

NOTIFY_CALLBACK_COORDINATOR_NO_AQ (new 23ai)

Undocumented dbms_saga_adm.notify_callback_coordinator_no_aq( in_queue_name IN VARCHAR2, out_queue_name IN VARCHAR2);

TBD

REGISTER_SAGA_CALLBACK (new 23ai)

Undocumented dbms_saga_adm.register_saga_callback( participant_name IN VARCHAR2, callback_schema IN VARCHAR2 DEFAULT sys_context('USERENV', 'CURRENT_USER'), callback_package IN VARCHAR2);

TBD