3 Replies Latest reply: Oct 15, 2013 9:07 AM by Anar Godjaev RSS

    Old values for CLOBs not stored in the LCR


      Hello, we have configured Oracle Streams as one-way replication (source at v11., destination v11. We are using a procedure dml handlers to ensure historization, anyway we are not able to get an old values for replicated CLOB columns for UPDATE/DELETE dml operation. New values getting correctly:


      v_clobcol_new   CLOB;

      v_clobcol_old   CLOB;


      v_clobcol_new := SYS.ANYDATA.accessClob (lcr.get_value ('NEW', 'CLOBCOL'))



      Anyway, for the command:

      v_clobcol_old := SYS.ANYDATA.accessClob (lcr.get_value ('OLD', 'CLOBCOL'))




      "ORA-26785: Object has a NULL value

      ORA-30625: method dispatch on NULL SELF argument is disallowed

      ORA-06512: at "DESTINATION.REPLICATED_TABLE", line 23

      ORA-06512: at line 1


      We cannot see old value for UPDATEd CLOB column in the message while printing LCR as well.

      How can we get old value please?


      Any help appreciated.

      Best regards,