Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Anyway to checksum a binary field in PLSQL

Re: Anyway to checksum a binary field in PLSQL

From: Richard Kuhler <noone_at_nowhere.com>
Date: Tue, 13 Nov 2001 20:09:12 GMT
Message-ID: <I5fI7.35349$D5.12665657@typhoon.san.rr.com>


Try UTL_RAW.SUBSTR

Richard

whome wrote:
>
> I have a table with a LONG RAW field. Is there anyway to create a
> checksum of the field within PL/SQL? I know how to do it in ProC,
> OCI or Java but was curious about doing the same only using PL/SQL.
> I found a couple of checksum routines for a varchar field. But the
> question I have is how to read byte by byte. Plus I have concerns
> about the PLSQL code handling a really large field in this manner.
>
> Thanks for hints.
Received on Tue Nov 13 2001 - 14:09:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US