Oracle | DBMS_SAGA_CONNECT

Oracle DBMS_SAGA_CONNECT_INT 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 CURRENT_USER

Dependencies

DBMS_ASSERT

DBMS_SAGA_ADM_SYS

Documented No

First Available 23ai

Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE and SAGA_CONNECT_ROLE roles.

Source {ORACLE_HOME}/rdbms/admin/dbmssagacon.plb
{ORACLE_HOME}/rdbms/admin/prvtsagacon.plb

Subprograms

CONNECTBROKERTOINQUEUE	GETBROKERINFO	UPDATECALLBACKINFO
DISCONNECTBROKERFROMINQUEUE	UNIQUEENTITYATPDB	VALIDATESECRET

CONNECTBROKERTOINQUEUE (new 23ai)

Undocumented dbms_saga_connect_int.connectBrokerToInQueue( participant_id IN RAW, entity_name_int IN VARCHAR2, entity_schema_int IN VARCHAR2, coordinatorparticipant 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, callback_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

DISCONNECTBROKERFROMINQUEUE (new 23ai)

Undocumented dbms_saga_connect_int.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_int IN VARCHAR2, entity_id IN RAW, saga_secret IN NUMBER);

TBD

GETBROKERINFO (new 23ai)

Undocumented dbms_saga_connect_int.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

UNIQUEENTITYATPDB (new 23ai)

Undocumented dbms_saga_connect_int.uniqueEntityAtPDB( entity_name IN VARCHAR2, broker_name IN VARCHAR2, mailbox_schema IN VARCHAR2, broker_pdb_link IN VARCHAR2, entity_dblink IN VARCHAR2) RETURN BOOLEAN;

BEGIN

        IF dbms_saga_connect_int.uniqueEntityAtPDB('A', 'A', 'A', 'A', 'A') THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      T

UPDATECALLBACKINFO (new 23ai)

Undocumented dbms_saga_connect_int.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_connect_int.validateSecret( entity_id IN RAW, saga_operation IN NUMBER, saga_secret IN NUMBER) RETURN BOOLEAN;

TBD