This discussion is archived
0 Replies Latest reply: Oct 15, 2013 6:04 AM by Santosh Pradhan RSS

Oracle Golden gate to use SQLEXEC & Filter clause

Santosh Pradhan Explorer
Currently Being Moderated



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!


  • Correct Answers - 10 points
  • Helpful Answers - 5 points