Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting the MD5 of an entire ROW ?

269171Jan 23 2008 — edited Jan 24 2008
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 21 2008
Added on Jan 23 2008
11 comments
9,831 views