Results 1 to 2 of 2

Thread: Error handling

  1. #1
    Join Date
    Feb 2004
    Posts
    16

    Unanswered: Error handling

    Hi,

    I am in the process of designing tables to capture the errors occurred while processing a pl/sql package and compute staistics like how many errors occurred while loading a particular entity and the reason.
    I am thinking of calling a stored proc in the exception handling to log
    and track errors in the following table.

    ID NUMBER
    ENTITY NUMBER
    PROGRAM_WHERE_ERROR_OCCURRED VARCHAR2(64)
    ERROR_CONTEXT VARCHAR2(1024)
    KEYFIELDS_IN_ERROR VARCHAR2(1024)
    ORACLE_ERRORCODE NUMBER
    ORACLE_ERRORMESSAGE VARCHAR2(256)
    EXCEPTION_RAISED VARCHAR2(64)
    ACTION_REQUIRED VARCHAR2(256)
    DATETIME_OF_ERROR DATE
    CREATION_DATE_TIME DATE

    We have a stored package which actually does the ETL part i.e; copying the source data to the target. I would like to capture the errors at every entity level.

    It would be of great help if you can give your valuable opinion, examples or suggestions.


    Thank you very much for your time.

    Regards,
    namoh

  2. #2
    Join Date
    Jul 2003
    Posts
    38
    Hi,
    I find more comfortable and useful to use "autonomous_transaction" feature for logging errors. So that whenever you find the error, you can log the same using a procedure which uses "autonomous_transaction". So that even if you rollback after loggin the error, only the processing part willbe rolled back and your error logging will get commited.

    avr.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •