Display Error Transaction Details

The procedures are:

• lcr_print_errors_all – This procedure is used to display all of the error transaction details.
   

• lcr_print_error – This procedure is used to display a specific error transaction detail.
   

• lcr_print_values – This procedure is called by both of the above two procedures. It actually displays the event details.

Using the code shown below the stored procedure named lcr_print_errors_all will be created:

Create_lcr_print_errors_all

-- *************************************************
-- Copyright © 2005 by Rampant TechPress
-- This script is free for non-commercial purposes
-- with no warranties.  Use at your own risk.
--
-- To license this script for a commercial purpose,
-- contact info@rampant.cc
-- *************************************************

-- To print all errors as obtained from the dba_apply_error
CREATE OR REPLACE PROCEDURE lcr_print_errors_all
IS
CURSOR C IS
SELECT LOCAL_TRANSACTION_ID,
 SOURCE_DATABASE, MESSAGE_NUMBER,