Golden Gate 12c not returning the source database name in a dml_handler package?
We have converted from streams to Golden Gate 12c. We are trying not to change the dml_handler packages we have in place. The problem our logic is failing.
We determined it was due specifically to this line >>>
lv_source_database:= lrec_rowlcr.get_source_database_name();
This works fine with streams, but for some reason when Golden Gate populates the LCR the source database name is not getting set. It is also null in the
V$GOLDENGATE_MESSAGE_TRACKING view.
Does anyone know how we get that value populated into the LCR?