Display Error Transaction Details
DBMS_OUTPUT.PUT_LINE('-- Source DB: ' ||
source);
-- DBMS_OUTPUT.PUT_LINE('-- Error in
Message: '|| msgno);
DBMS_OUTPUT.PUT_LINE('-- Error Number:
'||errno);
DBMS_OUTPUT.PUT_LINE('-- Message Text: '||
substr(errmsg,1,60) );
FOR i IN 1..msgcnt LOOP
DBMS_OUTPUT.PUT_LINE('In record Loop Msg:
' || i);
lcr := DBMS_APPLY_ADM.GET_ERROR_MESSAGE(i,
txnid);
lcr_print_values (lcr);
END LOOP;
END LOOP;
END lcr_print_errors_all;
/
This procedure calls another procedure,
lcr_print_values, which extracts the values from the
SYS.AnyData type event and displays. The lcr_print_values
code listing is located in the code depot.
To display information about a specified
transaction, the lcr_print_error procedure will be used.
The code listing is in the code depot and the transaction id
will be passed as a parameter.
This first part of a typical output listing
is shown below. Please refer to the code depot for the complete
listing.
DNYOIP20 SQL>set serveroutput on size
200000
DNYOIP20 SQL>exec LCR_PRINT_ERRORS_ALL ;
*************************************************
-- ERROR #1
