Streams LCR new values
edited Oct 13, 2010 4:17AM in GoldenGate, Streams and Distributed Database (MOSC) 6 commentsAnswered
I am playing around with Streams in Oracle 10.2. I want to capture updates and delete from the source (address) and insert them into a change table (address_change) using a dml handler function. I also add a timesatmap and command type field to the new table.
I was able to get it to work for deletes by creating a procedure similar to the example in the Streams Concept guide.
For the updates, I want to record the new values in the address table. Most examples, show storing the old values. However, if I select the new values, my new record, only has the changes. It doesn't have the original values or even the primary key.
I was able to get it to work for deletes by creating a procedure similar to the example in the Streams Concept guide.
For the updates, I want to record the new values in the address table. Most examples, show storing the old values. However, if I select the new values, my new record, only has the changes. It doesn't have the original values or even the primary key.
0