Re: Anyway to checksum a binary field in PLSQL

In article <3BF072CD.D43513E3_at_gnosis.com>, whome says...
>
>
>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.

PLSQL can read long raws that are 32k or less in size.

One byte bigger and it cannot be used.

In 8.0 and up, you should use a BLOB which would give you 100% access to the entire thing in any language.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp