Compare CLOBs over dblink

From: Sherrie Kubis <>
Date: Mon, 1 Nov 2010 10:34:18 -0400
Message-ID: <>

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<>

IMPORTANT NOTICE: All E-mail sent to or from this address are public record and archived. The Southwest Florida Water Management District does not allow use of District equipment and E-mail facilities for non-District business purposes.

Received on Mon Nov 01 2010 - 09:34:18 CDT

Original text of this message