Hello, we have configured Oracle Streams as one-way replication (source at v22.214.171.124.0, destination v126.96.36.199.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 := 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.