2 Replies Latest reply: Oct 16, 2012 9:39 AM by user476243 RSS

    Generic Error Handlers

    user476243
      11gR2(11.2.0.3) Linux 5 64bit

      Is there any way to create a general error handler that will handle all and any tables that have errors during the apply process as opposed to creating several error handlers for several tables? You can create an error handler for 1,2, 3 or more tables and it may resolve your issue, however, you don't know if some other table will have an error in the future or not.

      Any ideas/suggestions?

      Thanks.
        • 1. Re: Generic Error Handlers
          Satishbabu Gunukula
          Please see below links

          http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4684561825338
          http://docs.oracle.com/cd/B10501_01/appdev.920/a96624/07_errs.htm

          hope it clears all your doubts

          Regards
          Time for Change: Migrate your Non-RAC Database to RAC
          http://www.oracleracexpert.com/2012/10/time-for-change-migrate-your-non-rac.html
          Send mails using UTL_SMTP in Oracle
          http://www.oracleracexpert.com/2012/10/send-mails-using-utlsmtp-in-oracle.html
          • 2. Re: Generic Error Handlers
            user476243
            Thanks for the reply.

            Perhaps I missed it, but I don't see them mentioning anywhere a way to create a global error handler. I just see error handlers for specific tables.

            Thanks.