This discussion is archived
2 Replies Latest reply: Aug 26, 2013 11:50 AM by Joe Upshaw RSS

Issues with WWV_FLOW_ITEM.MD5 - Doesn't seem to be Determinant

Joe Upshaw Journeyer
Currently Being Moderated

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.

 

SELECT CHECK_BOX,

       RISK_PAYCOLL_ID,

       ORG_ID,

       ...

       WWV_FLOW_ITEM.MD5( VM_AMOUNT, DESCRIPTION ) AS CHECKSUM

FROM MIDAY_PAY_COLLECT

 

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?

 

-Joe

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points