4 Replies Latest reply on Apr 4, 2011 5:55 PM by Iancu Nicolae-Ciprian

    OWB 11gr2 ODI component how to get error table in control code template

    Iancu Nicolae-Ciprian
      Hi experts,
      Is there an way to get inside an Control Code Template (CCT_ORACLE) the setting of Error Table of an target table?
      We are working on an Control Code Template that should also log the errors after executing an command like:
      INSERT INTO table (fields..)
      SELECT * FROM src_table
      LOG ERRORS INTO ERR_TABLE ('INSERT') REJECT LIMIT UNLIMITED;

      and instead of ERR_TABLE I would like to get the error table setted by developer in the Error table configuration inside Property Inspector view. The same would be nice for getting the error limit from the mapping configuration page.


      Regards,
      Cipi