Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E25513-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub
REFRN20783

ALL_APPLY_ERROR_MESSAGES

ALL_APPLY_ERROR_MESSAGES displays information about the individual messages in an error transaction generated by the apply processes that dequeue messages from queues accessible to the current user.

Related View

DBA_APPLY_ERROR_MESSAGES displays information about the individual messages in all of the error transactions generated by all apply processes in the database.

Note:

Messages that were spilled from memory to hard disk do not appear in this view.
Column Datatype NULL Description
MESSAGE_ID RAW(16)   Unique identifier of the message stored in the error queue
LOCAL_TRANSACTION_ID VARCHAR2(22)   Local transaction ID for the error transaction
TRANSACTION_MESSAGE_NUMBER NUMBER   Message number of the message that raised the error. The message number is a sequence number for the messages in the transaction, starting with 1.
ERROR_NUMBER NUMBER   Error number of the error raised by the transaction. The error number is populated only for the LCR that raised the error. This field is NULL for the other LCRs in the transaction.
ERROR_MESSAGE VARCHAR2(4000)   Error message of the error raised by the transaction. The error message is populated only for the LCR that raised the error. This field is NULL for the other LCRs in the transaction.

Note:

The ALL_APPLY_ERROR_MESSAGES view is available starting with Oracle Database 11g Release 2 (11.2.0.2).
Reader Comment

   

Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums for product questions. For support or consulting, file a service request through My Oracle Support.

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

This Document

New and changed documents:
RSS Feed HTML RSS Feed PDF