get_error_message Function

The get_error_message procedure is very useful. This function returns the message payload from the error queue for the specified message number and transaction identifier. The message is an event which may be a LCR or a non-LCR event. With the help of this procedure, the DBA will be able to find out the inner details such as the source database name, old and new values, etc. Once the details of the payload have been read, the reason for failure can be established.

Syntax:

DBMS_APPLY_ADM.GET_ERROR_MESSAGE(
message_number                     IN NUMBER,
local_transaction_id      IN VARCHAR2,
destination_queue_name             OUT VARCHAR2,
execute                                     OUT BOOLEAN)
RETURN SYS.AnyData;

message_number is the identification number of the message of the Apply process. This number identifies the position of the message in the transaction. This number can be obtained from the dba_apply_error data dictionary view. local_transaction_id is the identifier of the error transaction.