I have an Interactive Report in which I include a call to WWV_FLOW_ITEM.MD5 to get the current checksum based on the value of a couple of updatable columns.
WWV_FLOW_ITEM.MD5( VM_AMOUNT, DESCRIPTION ) AS CHECKSUM
I am subsequently attempting to determine which rows have been changed by recalculating the check sum, again with WWV_FLOW_ITEM.MD5 using the VM_AMOUNT and DESCRIPTION as input fields. My expectation would be that, if the values of these fields had not been changed (or had been changed and subsequently changed back to their original values), the check sums would match. However, in every row, those changed or unchanged, I get a new, different value when I call WWV_FLOW_ITEM.MD5.
What am I missing?
Please use documented API's. See APEX_ITEM also please specify your APEX version.
As I know, all APIs in APEX_ITEM package return HTML to display item. So when comparing hidden item value, you need to recalculate check-sum using DBMS_CRYPTO or DBMS_OBFUSCATION_TOOLKIT.MD5 depending on your version. And then you have to compare check-sum value from Hidden Item with new calculated checksum value.