0 Replies Latest reply on Oct 15, 2013 1:04 PM by Santosh Pradhan

    Oracle Golden gate to use SQLEXEC & Filter clause

    Santosh Pradhan



      I am having requirement in which I need to use SQLEXEC with Procedure & FILTER parameters.


      Filtering will be based on target side column which is not available at source side, that means I can not use FILTER Clause in MAP statement.


      I have gone through  The Guidelines for using a standalone SQLEXEC parameter on page 294 of gg_wux_ref but not getting about how can I use SQLEXEC with Filter clause & filtering also has a condition i.e. I need to check the distinct value of 500 rows table & if distinct value is 0, I will use EVENTACTIONS to stop replicat.


      Can someone please suggest me on the same.


      Thank you!