Oracle | DBMS_SAGA

Oracle DBMS_SAGA_SYS 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 DEFINER

Dependencies

ALL_PROCEDURES	DBMS_SAGA_ADM	PLITBLM
AQ$_AGENT	DBMS_SAGA_ADM_SYS	SAGA$
AQ$_JMS_TEXT_MESSAGE	DBMS_SAGA_LIB	SAGA_ERRORS$
DBMS_AQ	DBMS_STANDARD	SAGA_PARTICIPANT$
DBMS_ASSERT	DBMS_SYSTEM	SAGA_PARTICIPANT_SET$
DBMS_SAGA	DBMS_UTILITY	V$PARAMETER

Documented No

First Available 23ai

Security Model Owned by SYS with no privileges granted

Direct access to this package is prevented by an Accessible By clause.

Source {ORACLE_HOME}/rdbms/admin/dbmsssaga.plb
{ORACLE_HOME}/rdbms/admin/prvtssaga.plb

Subprograms

BEGIN_SAGA	GET_SAGA_SPARE_NUM	SAGA_ESCROW_REPL
CHECK_SAGA_TIMEOUT	KWSAGA_3GL_CHECKPRIVILEGE	SAGA_REPL
COMMIT_SAGA	LOG_ERROR_REPL	SAGA_TIMEOUT_REPL
ENQUEUE_OPCODE	PROCESS_NOTIFICATION	SET_SAGA_BEGIN_TIME
GET_MAX_DURATION	ROLLBACK_SAGA	SET_SAGA_SPARE
GET_OUT_TOPIC	SAGA_DEL_REPL	SET_SAGA_SPARE_NUM
GET_SAGA_KEY	SAGA_DML_NOREPL	SET_SAGA_TIMEOUT
GET_SAGA_SPARE

BEGIN_SAGA (new 23ai)

Undocumented dbms_saga_sys.begin_saga( initiator_name IN VARCHAR2, timeout IN NUMBER, current_user IN VARCHAR2, version IN NUMBER);

TBD

CHECK_SAGA_TIMEOUT (new 23ai)

Undocumented dbms_saga_sys.check_saga_timeout(saga_id IN RAW) RETURN BOOLEAN;

TBD

COMMIT_SAGA (new 23ai)

Undocumented dbms_saga_sys.commit_saga( saga_participant IN VARCHAR2, saga_id IN RAW, force IN BOOLEAN, currnet_user IN VARCHAR2);

TBD

ENQUEUE_OPCODE (new 23ai)

Undocumented dbms_saga_sys.enqueue_opcode( saga_id IN RAW, owner IN VARCHAR2, sender IN VARCHAR2, recipient IN VARCHAR2, opcode IN NUMBER, q_partitions IN BINARY_INTEGER, completion_time IN TIMESTAMP WITH TIME ZONE, status IN NUMBER);

TBD

GET_MAX_DURATION (new 23ai)

Undocumented dbms_saga_sys.get_max_duration RETURN NUMBER;

SELECT dbms_saga_sys.get_max_duration;

             *

      ORA-06553: PLS-904" insufficient privilege to access object DBMS_SAGA_SYS

GET_OUT_TOPIC (new 23ai)

Undocumented dbms_saga_sys.get_out_topic( entity_name IN VARCHAR2, canonicalize IN BOOLEAN) RETURN VARCHAR2;

TBD

GET_SAGA_KEY (new 23ai)

Undocumented dbms_saga_sys.get_saga_key( sagaid IN RAW, name IN VARCHAR2, queue_partitions IN BINARY_INTEGER) RETURN BINARY_INTEGER;

TBD

GET_SAGA_SPARE (new 23ai)

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

TBD

GET_SAGA_SPARE_NUM (new 23ai)

Undocumented dbms_saga_sys.get_saga_spare_num(message IN OUT sys.aq$_jms_text_message) RETURN NUMBER;

TBD

KWSAGA_3GL_CHECKPRIVILEGE (new 23ai)

Undocumented dbms_saga_sys.kwSaga_3gl_checkPrivilege RETURN BOOLEAN;

TBD

LOG_ERROR_REPL (new 23ai)

Undocumented dbms_saga_sys.log_error_repl( saga_id IN RAW, participant IN VARCHAR2, sql_error IN VARCHAR2, sql_code IN VARCHAR2);

TBD

PROCESS_NOTIFICATION (new 23ai)

Undocumented dbms_saga_sys.process_notification( recipient IN VARCHAR2, sender IN VARCHAR2, saga_id IN RAW, opcode IN NUMBER, coordinator IN VARCHAR2, saga_timeout IN NUMBER, saga_version IN NUMBER, saga_spare IN VARCHAR2, begin_time IN TIMESTAMP WITH TIME ZONE, req_res IN CLOB);

TBD

ROLLBACK_SAGA (new 23ai)

Undocumented dbms_saga_sys.rollback_saga( saga_participant IN VARCHAR2, saga_id IN RAW, force IN BOOLEAN, current_user IN VARCHAR2);

TBD

SAGA_DEL_REPL (new 23ai)

Undocumented dbms_saga_sys.saga_del_repl(saga_retention IN NUMBER);

exec dbms_saga_sys.saga_del_repl(2);

           *

      PLS-00904 insufficient privilege to access object DBMS_SAGA_SYS

SAGA_DML_NOREPL (new 23ai)

Undocumented dbms_saga_sys.saga_dml_norepl;

TBD

SAGA_ESCROW_REPL (new 23ai)

Undocumented dbms_saga_sys.saga_escrow_repl( saga_id IN RAW, txn_id IN RAW, participant IN VARCHAR2, user_id IN NUMBER, obj_num IN NUMBER, opcode IN NUMBER);

TBD

SAGA_REPL (new 23ai)

Undocumented dbms_saga_sys.saga_repl( saga_id IN RAW, participant_name IN VARCHAR2, coordinator_name IN VARCHAR2, initiator_name IN VARCHAR2, owner_shcmea IN VARCHAR2, saga_timeout IN NUMBER, saga_version IN NUMBER, begin_time IN TIMESTAMP WITH TIME ZONE, saga_opcode IN NUMBER, saga_routine IN NUMBER);

TBD

SAGA_TIMEOUT_REPL (new 23ai)

Undocumented dbms_saga_sys.saga_timeout_repl( saga_id IN RAW, participant IN VARCHAR2);

TBD

SET_SAGA_BEGIN_TIME (new 23ai)

Undocumented dbms_saga_sys.set_saga_begin_time( message IN OUT sys.aq$_jms_text_message, begin_time IN TIMESTAMP WITH TIME ZONE);

TBD

SET_SAGA_SPARE (new 23ai)

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

TBD

SET_SAGA_SPARE_NUM (new 23ai)

Undocumented dbms_saga_sys.set_saga_spare_num( message IN OUT sys.aq$_jms_text_message, saga_spae_num IN NUMBER);

TBD

SET_SAGA_TIMEOUT (new 23ai)

Undocumented dbms_saga_sys.set_saga_timeout( message IN OUT sys.aq$_jms_text_message, saga_timeout IN NUMBER);

TBD