How big do the LOBS get? I wouldn't want to compare multi mb files over a link.... On Mon, Nov 1, 2010 at 3:28 PM, <japplewhite@xxxxxxxxxxxxx> wrote: > 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 <Sherrie.Kubis@xxxxxxxxxxxxxxxxxx> > To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx> > Date: 11/01/2010 09:36 AM > Subject: Compare CLOBs over dblink > Sent by: oracle-l-bounce@xxxxxxxxxxxxx > ------------------------------ > > > > 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@xxxxxxxxxxxxxxxx* <Sherrie.Kubis@xxxxxxxxxxxxxxxx>* > **http://www.watermatters.org* <http://www.watermatters.org/> > > > -- Niall Litchfield Oracle DBA http://www.orawin.info