Compare CLOBs over dblink
From: Sherrie Kubis <Sherrie.Kubis_at_swfwmd.state.fl.us>
Date: Mon, 1 Nov 2010 10:34:18 -0400
Message-ID: <EF39FBA0AC25BF4CA65F6ADC861ADF6071113C1CC5_at_EXMAIL01.ad.swfwmd.net>
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.
Date: Mon, 1 Nov 2010 10:34:18 -0400
Message-ID: <EF39FBA0AC25BF4CA65F6ADC861ADF6071113C1CC5_at_EXMAIL01.ad.swfwmd.net>
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
mailto:Sherrie.Kubis_at_watermatters.org
http://www.watermatters.org<http://www.watermatters.org/>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 01 2010 - 09:34:18 CDT