This discussion is archived
1 Reply Latest reply: Sep 4, 2013 7:54 AM by ankitbarsainya RSS

Extracting the DML queries by LCR in Oracle and send them over to IBM MQ

HeSi9466 Newbie
Currently Being Moderated


My question is mostly about the concept of LCR (logical change recortds in Oracle Streams)


I want to extract any DML script which has been applied to one specific table, but i don't want to apply this DML anywhere , I just want to send it over by AQ in oracle and then

the MQ queues in IBM will recieve it.

I don't know what the Mainframe guys are going to do with it but my task is to just send them the script?


Do you think it's possible using the LCRs?


Thanks in advance for comments!


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