Oracle | DBMS

Oracle DBMS_SAGA 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 architecture support subprograms (also known as Epic).

AUTHID CURRENT_USER

Constants

Name	Data Type	Value
OPCODEs
CMT_SAGA	NUMBER	2
ABRT_SAGA	NUMBER	4
REQUEST	NUMBER	7
RESPONSE	NUMBER	8
CMT_FAIL	NUMBER	9
ABRT_FAIL	NUMBER	10

Data Types subtype saga_id_t IS RAW(16);

Dependencies

AQ$_DESCRIPTOR	DBMS_SAGA_ADM	DBMS_STNDARD
AQ$_JMS_TEXT_MESSAGE	DBMS_SAGA_ADM_SYS	DBMS_SYSTEM
AQ$_REG_INFO	DBMS_SAGA_LIB	DBMS_UTILITY
DBMS_AQ	DBMS_SAGA_SYS

Documented Yes: Packages and Types Reference

Exceptions

Error Code	Reason
ORA-45493	ROLLINGUNSUPPORTED

First Available 23.1 Beta

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, NONE);

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

Source {ORACLE_HOME}/rdbms/admin/dbmssaga.sql
{ORACLE_HOME}/rdbms/admin/prvtsaga.plb

Subprograms

AFTER_SAGA	GET_SAGA_RECIPIENT	SEND_REQUEST
BEGIN_SAGA	GET_SAGA_SENDER	SET_INCOMPLETE
COMMIT_SAGA	GET_SAGA_SPARE	SET_SAGA_COORDINATOR
FORGET_SAGA	GET_SAGA_TIMEOUT	SET_SAGA_ID
GET_OUT_TOPIC	GET_SAGA_VERSION	SET_SAGA_OPCODE
GET_SAGA_BEGIN_TIME	IS_INCOMPLETE	SET_SAGA_RECIPIENT
GET_SAGA_COORDINATOR	LEAVE_SAGA	SET_SAGA_SENDER
GET_SAGA_ID	NOTIFY_CALLBACK_PARTICIPANT	SET_SAGA_SPARE
GET_SAGA_OPCODE	ROLLBACK_SAGA	SET_SAGA_VERSION

AFTER_SAGA (new 23c)

Undocumented dbms_saga.after_saga(saga_id IN saga_id_t);

TBD

BEGIN_SAGA (new 23c)

Undocumented dbms_saga.begin_saga( initiator_name IN VARCHAR2, timeout IN NUMBER DEFAULT 0, version IN NUMBER DEFAULT 1) RETURN saga_id_t;

TBD

COMMIT_SAGA (new 23c)

Undocumented dbms_saga.commit_saga( saga_participant IN VARCHAR2, saga_id IN saga_id_t, force IN BOOLEAN DEFAULT FALSE);

TBD

FORGET_SAGA (new 23c)

Undocumented dbms_saga.forget_saga(saga_id IN saga_id_t);

TBD

GET_OUT_TOPIC (new 23c)

Undocumented dbms_saga.get_out_topic( entity_name IN VARCHAR2, canonicalize IN BOOLEAN DEFAULT TRUE) RETURN VARCHAR2;

TBD

GET_SAGA_BEGIN_TIME (new 23c)

Undocumented dbms_saga.get_saga_begin_time(message IN OUT sys.aq$_jms_text_message) RETURN TIMESTAMP WITH TIME ZONE;

TBD

GET_SAGA_COORDINATOR (new 23c)

Undocumented dbms_saga.get_saga_coordinator(message IN OUT sys.aq$_jms_text_message) RETURN VARCHAR2;

TBD

GET_SAGA_ID (new 23c)

Undocumented

Overload 1 dbms_saga.get_saga_id RETURN saga_id_t;

TBD

Overload 2 dbms_saga.get_saga_id(message IN OUT sys.aq$_jms_text_message) RETURN RAW;

TBD

GET_SAGA_OPCODE (new 23c)

Undocumented dbms_saga.get_saga_opcode(message IN OUT sys.aq$_jms_text_message) RETURN NUMBER;

TBD

GET_SAGA_RECIPIENT (new 23c)

Undocumented dbms_saga.get_saga_recipient(message IN OUT sys.aq$_jms_text_message) RETURN VARCHAR2;

TBD

GET_SAGA_SENDER (new 23c)

Undocumented dbms_saga.get_saga_sender(message IN OUT sys.aq$_jms_text_message) RETURN VARCHAR2;

TBD

GET_SAGA_SPARE (new 23c)

Undocumented dbms_saga.get_saga_spare(message IN OUT sys.aq$_jms_text_message) RETURN VARCHAR2;

TBD

GET_SAGA_TIMEOUT (new 23c)

Undocumented dbms_saga.get_saga_timeout(message IN OUT sys.aq$_jms_text_message) RETURN NUMBER;

TBD

GET_SAGA_VERSION (new 23c)

Undocumented dbms_saga.get_saga_version(message IN OUT sys.aq$_jms_text_message) RETURN NUMBER;

TBD

IS_INCOMPLETE (new 23c)

Undocumented dbms_saga.is_incomplete(saga_id IN saga_id_t) RETURN BOOLEAN;

TBD

LEAVE_SAGA (new 23c)

Undocumented dbms_saga.leave_saga(saga_id IN saga_id_t);

TBD

NOTIFY_CALLBACK_PARTICIPANT (new 23c)

Undocumented dbms_saga.notify_callback_participant( context IN RAW, reginfo IN sys.aq$_reg_info, descr IN sys.aq$_descriptor, payload IN RAW, payloadl IN NUMBER);

TBD

ROLLBACK_SAGA (new 23c)

Undocumented dbms_saga.rollback_saga( saga_participant IN VARCHAR2, saga_id IN saga_id_t, force IN BOOLEAN DEFAULT FALSE);

TBD

SEND_REQUEST (new 23c)

Undocumented dbms_saga.send_request( saga_id IN saga_id_t, recipient IN VARCHAR2, payload IN JSON DEFAULT NULL, saga_version IN NUMBER DEFAULT 1, saga_spare IN VARCHAR2 DEFAULT NULL);

TBD

SET_INCOMPLETE (new 23c)

Undocumented dbms_saga.set_incomplete(saga_id IN saga_id_t);

TBD

SET_SAGA_COORDINATOR (new 23c)

Undocumented dbms_saga.set_saga_coordinator( message IN OUT sys.aq$_jms_text_message, saga_coordinator IN VARCHAR2, canonicalize IN BOOLEAN DEFAULT TRUE);

TBD

SET_SAGA_ID (new 23c)

Undocumented

Overload 1 dbms_saga.set_saga_id(saga_id IN saga_id_t);

TBD

Overload 2 dbms_saga.set_saga_id( message IN OUT sys.aq$_jms_text_message, saga_id IN RAW);

TBD

SET_SAGA_OPCODE (new 23c)

Undocumented dbms_saga.set_saga_opcode( message IN OUT sys.aq$_jms_text_message, saga_id IN saga_id_t, opcode IN NUMBER);

TBD

SET_SAGA_RECIPIENT (new 23c)

Undocumented dbms_saga.set_saga_recipient( message IN OUT sys.aq$_jms_text_message, recipient IN VARCHAR2, canonicalize IN BOOLEAN DEFAULT TRUE);

TBD

SET_SAGA_SENDER (new 23c)

Undocumented dbms_saga.set_saga_sender( message IN OUT sys.aq$_jms_text_message, sender IN VARCHAR2, canonicalize IN BOOLEAN DEFAULT TRUE);

TBD

SET_SAGA_SPARE (new 23c)

Undocumented dbms_saga.set_saga_spare( message IN OUT sys.aq$_jms_text_message, saga_spare IN VARCHAR2, canonicalize IN BOOLEAN DEFAULT TRUE);

TBD

SET_SAGA_VERSION (new 23c)

Undocumented dbms_saga.set_saga_version( message IN OUT sys.aq$_jms_text_message, saga_version IN NUMBER);

TBD