4.46 ALL_SAGA_ERRORS

ALL_SAGA_ERRORS describes errors generated by the sagas accessible to the current user.

This view displays sagas that were either initiated in the current PDB or joined by participants in the current PDB.

Related Views

  • DBA_INCOMPLETE_SAGAS describes errors generated by all sagas in the database.

  • USER_SAGA_ERRORS describes errors generated by the sagas owned by the current user.

Column Datatype NULL Description

SAGA_ID

RAW(16)

Saga ID

PARTICIPANT

VARCHAR2(128)

Name of the saga participant

SQL_ERROR

VARCHAR2(200)

SQL error

SQL_CODE

VARCHAR2(7)

SQL error code

ERROR_TIME

VARCHAR2(19)

Time at which the error occurred

ERROR_ANNOTATIONFoot 1

VARCHAR2(128)

  

Annotation on the function that caused the error

ERROR_FUNCTIONFoot 1

VARCHAR2(4000)

  

Name of the function that caused the error

Footnote 1 This column is available starting with Oracle Database 23ai, Release Update 23.9.

Note:

This view is available starting with Oracle Database 23ai.

See Also: