1 Reply Latest reply on Aug 19, 2019 4:13 PM by Vikas Panwar

    Replicat ignore ORA-01403 on DELETE

    user8549197

      Hello,

       

      Could somebody please help me with following problem?

      I want the "replicat" to IGNORE/DISCARD ORA-01403 error, for this I added REPERROR at the end of the MAP as in the following line:

       

      MAP T_REPORT, TARGET T_REPORT  REPERROR(1403,DISCARD);

       

      The problem is that it ignore/discard ORA-01403 (No data found) for all operations (DELETE and UPDATE) but I want it do be valid only for DELETE. So I need something like this

       

      MAP T_REPORT, TARGET T_REPORT  REPERROR(1403,DISCARD, 'ON DELETE');

       

      but ofcourse REPERROR does't work like this, does anybody has an idea how to achieve this result?  (to ignore "data not found" only for DELETE operation)

       

      (OracleDB  verion 12, GG version 12.3..)

      THANKS!!!!

        • 1. Re: Replicat ignore ORA-01403 on DELETE
          Vikas Panwar

          Hi user8549197,

           

          one approach which I can quickly think of:

           

          getinserts

          getupdates

          ignoredeletes

          put all statements here for which you want this functionality

           

          ignoreinserts

          ignoreupdates

          getdeletes

          put all statements here for which you want this functionality

           

          -- below commands so that below this whatever you will add that will have regular processing

          getinserts

          getupdates    

           

           

          Hope this helps

          mark it correct, helpful or like it appropriately. This will help others also

           

          -VP