Getting the MD5 of an entire ROW ?
269171Jan 23 2008 — edited Jan 24 2008Hi All,
I'm looking for how to get the MD5 of an entire row (or a known set of columns).
I've found the DBMS_OBFUSCATION_TOOLKIT.MD5 function, which takes either "input IN RAW" or "input_string IN VARCHAR2" as a parameter.
So, I've three questions:
1) Is is possible to get the entire value Row in a manner to pass into this function? (e.g. As a String)
2) Is this DBMS_OBFUSCATION_TOOLKIT package only in Enterprise edition and not in Standard edition ? (How do I check this)
3) or Is there a better way to get the MD5 of a Row ??
My row of data will contain a column of type MDSYS.SDO_GEOMETRY.
Cheers,
Ronan