Data Dictionary Views, 86 of 112

DEFERROR

Contains the ID of each transaction that could not be applied. You can use this ID to locate the queued calls associated with this transaction. These calls are stored in the DEFCALL view. You can use the procedures in the DBMS_DEFER_QUERY package to determine the arguments to the procedures listed in the DEFCALL view.

Column Datatype NULL Description

DEFERRED_TRAN_ID

VARCHAR2(22)

NOT NULL

The ID of the transaction causing the error.

ORIGIN_TRAN_DB

VARCHAR2(128)

The database originating the deferred transaction.

ORIGIN_TRAN_ID

VARCHAR2(22)

The original ID of the transaction.

CALLNO

NUMBER

Unique ID of the call at DEFERRED_TRAN_ID.

DESTINATION

VARCHAR2(128)

Database link used to address destination.

START_TIME

DATE

Time when the original transaction was enqueued.

ERROR_NUMBER

NUMBER

Oracle error number.

ERROR_MSG

VARCHAR2(2000)

Error message text.

RECEIVER

VARCHAR2(30)

Original receiver of the deferred transaction.

Column	Datatype	NULL	Description
`DEFERRED_TRAN_ID`	`VARCHAR2(22)`	`NOT NULL`	The ID of the transaction causing the error.
`ORIGIN_TRAN_DB`	`VARCHAR2(128)`		The database originating the deferred transaction.
`ORIGIN_TRAN_ID`	`VARCHAR2(22)`		The original ID of the transaction.
`CALLNO`	`NUMBER`		Unique ID of the call at DEFERRED_TRAN_ID.
`DESTINATION`	`VARCHAR2(128)`		Database link used to address destination.
`START_TIME`	`DATE`		Time when the original transaction was enqueued.
`ERROR_NUMBER`	`NUMBER`		Oracle error number.
`ERROR_MSG`	`VARCHAR2(2000)`		Error message text.
`RECEIVER`	`VARCHAR2(30)`		Original receiver of the deferred transaction.