1 Reply Latest reply: Sep 4, 2013 9:54 AM by ankitbarsainya RSS

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



      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!