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 will be available on generic Linux platforms in January and soon on AIX and Windows

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