Oracle | DBMS_SAGA_ADM

Oracle DBMS_SAGA_ADM_SYS 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 support subprograms

AUTHID DEFINER

Dependencies

ALL_PROCEDURES	DBMS_AQ	DBMS_UTILITY
ALL_USERS	DBMS_AQADM	DUAL
AQ$_AGENT	DBMS_ASSERT	GV$PERSISTENT_QUEUES
AQ$_JMS_TEXT_MESSAGE	DBMS_RANDOM	PLITBLM
AQ$_REG_INFO	DBMS_SAGA	SAGA$
AQ$_REG_INFO_LIST	DBMS_SAGA_ADM	SAGA_DETAILS$
DBA_QUEUE_TABLES	DBMS_SAGA_CONNECT_INT	SAGA_MESSAGE_BROKER$
DBA_ROLE_PRIVS	DBMS_SAGA_LIB	SAGA_PARTICIPANT$
DBA_SCHEDULER_JOBS	DBMS_SAGA_SYS	SAGA_PARTICIPANT_SET$
DBA_SYS_PRIVS	DBMS_SCHEDULER	SAGA_SECRETS$
DBA_TAB_PRIVS	DBMS_SYSTEM	V$PARAMETER

Documented No

First Available 23ai

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/dbmsssagaadm.plb
{ORACLE_HOME}/rdbms/admin/prvtssagaadm.plb

Subprograms

ADD_BROKER	DROP_BROKER	PROCESS_NOTIFICATION_REPL
ADD_COORDINATOR	DROP_COORDINATOR	REGISTER_SAGA_CALLBACK
ADD_PARTICIPANT	DROP_PARTICIPANT	UNIQUEENTITYATPDB
CONNECTBROKERTOINQUEUE	GETBROKERINFO	UPDATECALLBACKINFO
CUD_SAGA_ENTITY	MONITOR_COORDINATOR_QUEUES	VALIDATESECRET
DISCONNECTBROKERFROMINQUEUE	PROCESS_NOTIFICATION

ADD_BROKER (new 23ai)

Undocumented dbms_saga_adm_sys.add_broker( broker_guid IN RAW, broker_name IN VARCHAR2, broker_schema IN VARCHAR2, storage_clause IN VARCHAR2, current_user IN VARCHAR2, version IN NUMBER);

TBD

ADD_COORDINATOR (new 23ai)

Undocumented dbms_saga_adm_sys.add_coordinator( coordinator_guid IN RAW, coordinator_name IN VARCHAR2, coordinator_schema IN VARCHAR2, storage_clause IN VARCHAR2, dblink_to_broker IN VARCHAR2, mailbox_schema IN VARCHAR2, broker_name IN VARCHAR2, dblink_to_coordinator IN VARCHAR2, current_user IN VARCHAR2, version IN NUMBER);

TBD

ADD_PARTICIPANT (new 23ai)

Undocumented dbms_saga_adm_sys.add_participant( participant_guid IN RAW, participant_name IN VARCHAR2, participant_schema IN VARCHAR2, storage_clause IN VARCHAR2, coordinator_name IN VARCHAR2, dblink_to_broker IN VARCHAR2, mailbox_schema IN VARCHAR2, broker_name IN VARCHAR2, callback_schema IN VARCHAR2, callback_package IN VARCHAR2, dblink_to_participant IN VARCHAR2, current_user IN VARCHAR2, version IN NUMBER);

TBD

CONNECTBROKERTOINQUEUE (new 23ai)

Undocumented dbms_saga_adm_sys.connectBrokerToInQueue( participant_id IN RAW, entity_name_int IN VARCHAR2, entity_schema_int IN VARCHAR2, coordinatororparticipant IN NUMBER, broker_id IN RAW, coordinator_id IN RAW, dblink_to_broker_int IN VARCHAR2, dblink_to_entity_int IN VARCHAR2, inbound_queue IN VARCHAR2, outbound_queue IN VARCHAR2, callaback_schema_int IN VARCHAR2, callback_package_int IN VARCHAR2, participant_iscomplete IN NUMBER, broker_schema_int IN VARCHAR2, broker_name_int IN VARCHAR2, version IN NUMBER, saga_secret IN NUMBER);

TBD

CUD_SAGA_ENTITY (new 23ai)

Undocumented dbms_saga_adm_sys.cud_saga_entity( operation IN NUMBER, entity_guid IN RAW, entity_name_int IN VARCHAR2, entity_schema_int IN VARCHAR2, in_queue IN VARCHAR2, out_queue IN VARCHAR2, remote IN NUMBER, version IN NUMBER, queue_partitions IN NUMBER, queue_type IN NUMBER, type IN NUMBER, broker_id IN RAW, coordinator_id IN RAW, dblink_to_broker_int IN VARCHAR2, dblink_to_entity_int IN VARCHAR2, calback_schema_int IN VARCHAR2, callback_package_int IN VARCHAR2, entity_complete IN NUMBER, listener_count IN NUMBER, saga_secret IN NUMBER);

TBD

DISCONNECTBROKERFROMINQUEUE (new 23ai)

Undocumented dbms_saga_adm_sys.disconnectBrokerFromInQueue( entity_name_int IN VARCHAR2, entity_schema_int IN VARCHAR2, dblink_to_entity_int IN VARCHAR2, broker_schema_int IN VARCHAR2, broker_name_int IN VARCHAR2, dblink_to_broker IN VARCHAR2, entity_id IN RAW, saga_secret IN NUMBER);

TBD

DROP_BROKER (new 23ai)

Undocumented dbms_saga_adm_sys.drop_broker(broker_name IN VARCHAR2);

TBD

DROP_COORDINATOR (new 23ai)

Undocumented dbms_saga_adm_sys.drop_coordinator(coordinator_name IN VARCHAR2);

TBD

DROP_PARTICIPANT (new 23ai)

Undocumented dbms_saga_adm_sys.drop_participant(participant_name IN VARCHAR2);

TBD

GETBROKERINFO (new 23ai)

Undocumented dbms_saga_adm_sys.getBrokerInfo( broker_id IN OUT RAW, broker_name IN OUT VARCHAR2, broker_schema IN OUT VARCHAR2, broker_version IN OUT NUMBER, iscreate IN BOOLEAN);

TBD

MONITOR_COORDINATOR_QUEUES (new 23ai)

Undocumented dbms_saga_adm_sys.monitor_coordinator_queues( entity_name_int IN VARCHAR2, partitions IN NUMBER);

TBD

PROCESS_NOTIFICATION (new 23ai)

Undocumented dbms_saga_adm_sys.process_notification( recipient IN VARCHAR2, sender IN VARCHAR2, deq_saga_id IN RAW, opcode IN NUMBER, coordinator IN VARCHAR2, saga_spare IN VARCHAR2, req_res IN CLOB);

TBD

PROCESS_NOTIFICATION_REPL (new 23ai)

Undocumented dbms_saga_adm_sys.process_notification_repl( sagaid IN RAW, sender IN VARCHAR2, saga_status IN NUMBER, opcode IN NUMBER, recipient IN VARCHAR2);

TBD

REGISTER_SAGA_CALLBACK (new 23ai)

Undocumented dbms_saga_adm_sys.register_saga_callback( participant_name IN VARCHAR2, callback_schema IN VARCHAR2, callback_package IN VARCHAR2);

TBD

UNIQUEENTITYATPDB (new 23ai)

Undocumented dbms_saga_adm_sys.uniqueEntityAtPDB( entity_name IN VARCHAR2, broker_name IN VARCHAR2, mailbox_schema IN VARCHAR2, broker_pdb_link IN VARCHAR2, entity_dblink IN VARCHAR2) REETURN BOOLEAN;

TBD

UPDATECALLBACKINFO (new 23ai)

Undocumented dbms_saga_adm_sys.updateCallbackInfo( cbk_schema IN VARCHAR2, cbk_package IN VARCHAR2, p_status IN NUMBER, p_id IN RAW, saga_secret IN NUMBER);

TBD

VALIDATESECRET (new 23ai)

Undocumented dbms_saga_adm_sys.validateSecret( entity_id IN RAW, saga_operation IN NUMBER, saga_secret IN NUMBER) RETURN BOOLEAN;

TBD