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 is now availble. If you haven't you downloaded already: Why?

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