Re: Compare CLOBs over dblink

From: Mark Weaver <mark-clist@xxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Wed, 03 Nov 2010 18:29:23 +0000

On 01/11/2010 15:59, Andy Klock wrote:

I don't have experience comparing "large" lobs over a db link, but I'd
be inclined to use your dbms_crypto.hash method.  Create a new function
that just calls dbms_crypto.hash and grant execute on that to your
developer.

Why wouldn't you just grant them execute on dbms_crypto?
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: Compare CLOBs over dblink
From: Niall Litchfield

Re: Compare CLOBs over dblink
From: Andy Klock

References:
- Compare CLOBs over dblink
  - From: Sherrie Kubis
- Re: Compare CLOBs over dblink
  - From: japplewhite
- Re: Compare CLOBs over dblink
  - From: Niall Litchfield
- Re: Compare CLOBs over dblink
  - From: Kellyn Pedersen
- Re: Compare CLOBs over dblink
  - From: Andy Klock

Other related posts:

» Compare CLOBs over dblink - Sherrie Kubis
» Re: Compare CLOBs over dblink - japplewhite
» Re: Compare CLOBs over dblink - Niall Litchfield
» Re: Compare CLOBs over dblink - Kellyn Pedersen
» Re: Compare CLOBs over dblink - Andy Klock
» Re: Compare CLOBs over dblink - Rich Jesse
» Re: Compare CLOBs over dblink - Martin Bach
» Re: Compare CLOBs over dblink - Martin Bach
» Re: Compare CLOBs over dblink - Mark Weaver
» Re: Compare CLOBs over dblink - Niall Litchfield
» Re: Compare CLOBs over dblink - Andy Klock

Browse oracle-l