Compare lob fields
Carlos, February 03, 2022 - 10:42 am UTC
I am using dbms_lob.compare in a trigger with :NEW and :OLD values and dbms_lob.length with the same variables. And when my process update the same BLOB value that exists previosuly, compare function returns 1 but length function returns the same value for :NEW and :OLD values.
Could be possible that dbms_lob.compare with :OLD values does not work?
February 03, 2022 - 6:27 pm UTC
If compare returns 1, the values are different - what is it you're expecting to happen?
Can you provide a test case?