Oracle | DBMS_SAGA

Oracle DBMS_SAGA_ADM Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose SAGA Microservices Administrative Interface

AUTHID CURRENT_USER

Dependencies

AQ$_DESCRIPTOR	DBMS_AQ	DBMS_SAGA_ADM_SYS
AQ$_JMS_TEXT_MESSAGE	DBMS_SAGA	DBMS_SYSTEM
AQ$_REG_INFO

Documented Yes: Packages and Types Reference

Exceptions

Error Code	Reason
ORA-45493	ROLLINGUNSUPPORTED

First Available 23.1 Beta

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_BROKER	NOTIFY_CALLBACK_COORDINATOR
ADD_COORDINATOR	DROP_COORDINATOR	REGISTER_SAGA_CALLBACK
ADD_PARTICIPANT	DROP_PARTICIPANT

ADD_BROKER (new 23c)

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 23c)

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 23c)

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 23c)

Undocumented dbms_saga_adm.drop_broker(broker_name IN VARCHAR2);

TBD

DROP_COORDINATOR (new 23c)

Undocumented dbms_saga_adm.drop_coordinator(coordinator_name IN VARCHAR2);

TBD

DROP_PARTICIPANT (new 23c)

Undocumented dbms_saga_adm.drop_participant(participant_name IN VARCHAR2);

TBD

NOTIFY_CALLBACK_COORDINATOR (new 23c)

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

REGISTER_SAGA_CALLBACK (new 23c)

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