Oracle | DBMS_SAGA

Oracle DBMS_SAGA_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_SAGA_ADM_SYS	SAGA$
AQ$_AGENT	DBMS_SAGA_LIB	SAGA_ERRORS$
AQ$JMS_TEXT_MESSAGE	DBMS_SYSTEM	SAGA_PARTICIPANT$
DBMS_AQ	DBMS_UTILITY	SAGA_PARTICIPANT_SET$
DBMS_ASSERT	PLITBLM	V$PARAMETER
DBMS_SAGA

Documented No

First Available 23.1

Security Model Owned by SYS with no privileges granted

The subprograms in this package are protected by an Accessible By clause.

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

Subprograms

BEGIN_SAGA	KWSAGA_3GL_CHECKPRIVILEGE	SAGA_DML_NOREPL
CHECK_SAGA_TIMEOUT	LOG_ERROR_REPL	SAGA_ESCROW_REPL
COMMIT_SAGA	PROCESS_NOTIFICATION	SAGA_REPL
GET_MAX_DURATION	ROLLBACK_SAGA	SAGA_TIMEOUT_REPL
GET_OUT_TOPIC	SAGA_DEL_REPL

BEGIN_SAGA (new 23c)

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

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

TBD

COMMIT_SAGA (new 23c)

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

TBD

GET_MAX_DURATION (new 23c)

Undocumented dbms_saga_sys.get_max_duration RETURN NUMBER;

TBD

GET_OUT_TOPIC (new 23c)

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

TBD

KWSAGA_3GL_CHECKPRIVILEGE (new 23c)

Undocumented dbms_saga_sys.kwSaga_3gl_checkPrivilege RETURN BOOLEAN;

TBD

LOG_ERROR_REPL (new 23c)

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

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

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

Undocumented dbms_saga_sys.saga_del_repl(saga_retention IN NUMBER);

exec dbms_saga_sys.saga_del_repl(2);

           *

      ERROR at line 1:

      ORA-06550 line 1, column 7:

      PLS-00904 insufficient privilege to access object DBMS_SAGA_SYS

      ORA-06550 line 1, columns 1

      PL/SQL: Statement ignored

SAGA_DML_NOREPL (new 23c)

Undocumented dbms_saga_sys.saga_dml_norepl;

TBD

SAGA_ESCROW_REPL (new 23c)

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

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

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

TBD