Re: Compare CLOBs over dblink

From: <>
Date: Mon, 1 Nov 2010 10:28:26 -0500
Message-ID: <>

How about the DBMS_LOB.Compare function?

Jack C. Applewhite - Database Administrator Austin I.S.D. - MIS Department
512.414.9250 (wk) / 512.935.5929 (pager)

From: Sherrie Kubis <> To: "" <> Date: 11/01/2010 09:36 AM

Subject:        Compare CLOBs over dblink
Sent by:

I have a developer request to compare CLOB fields over a dblink. We looked at dbms_utility.get_hash_value but that only works for varchar data types. We then looked at dbms_crypto.hash, which has potential. My concern with this is granting dbms_crypto to a developer as a security issue.  

Anyone have an experience or advice on comparing clobs over a dblink or the dbms_crypto package?    

Sherrie Kubis
Oracle DBA Supervisor
Southwest Florida Water Management District 352-796-7211 x4033  

Received on Mon Nov 01 2010 - 10:28:26 CDT

Original text of this message