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

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