GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

streams : capture parent column based on child for delete

edited Aug 30, 2016 5:00AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered ✓

I am using oracle 12.1.0.2. 

We  have streams process that captures organizations (org_pk) whose  records changed for DML (I/U/D) for a  subset of tables   For one of the tables,  I need to capture org_pk based on status_code column of  its child table.  I am able to simply SELECT this value   when lcr.GET_COMMAND_TYPE() = 'INSERT' and 'UPDATE'. However, for 'DELETE',  I am not able to  select child's status_code  as the  record is already deleted when parent is deleted.

Please suggest how can I handle capturing a column in parent for  DELETE based on status_code column of child table.

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