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

    Old values for CLOBs not stored in the LCR

    user10912385

      Hello, we have configured Oracle Streams as one-way replication (source at v11.1.0.7.0, destination v11.2.0.3.0). 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'))

       

      getting:

       

      "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,

      TukanTeam