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

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