GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Golden Gate 12c not returning the source database name in a dml_handler package?

edited Oct 13, 2017 5:02AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center