Oracle | DBMS_SAGA_ADM

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

AUTHID DEFINER

Dependencies

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

Documented No

First Available 23.1 Beta

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
DISCONNECTBROKERFROMINQUEUE	PROCESS_NOTIFICATION	VALIDATESECRET

ADD_BROKER (new 23c)

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

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

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

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

DISCONNECTBROKERFROMINQUEUE (new 23c)

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

Undocumented dbms_saga_adm_sys.drop_broker(broker_name IN VARCHAR2);

TBD

DROP_COORDINATOR (new 23c)

Undocumented dbms_saga_adm_sys.drop_coordinator(coordinator_name IN VARCHAR2);

TBD

DROP_PARTICIPANT (new 23c)

Undocumented dbms_saga_adm_sys.drop_participant(participant_name IN VARCHAR2);

TBD

GETBROKERINFO (new 23c)

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

PROCESS_NOTIFICATION (new 23c)

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

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

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

TBD

UNIQUEENTITYATPDB (new 23c)

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

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

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

TBD