Re: CLOB Replacement - RTF format data

On 12 Nov, 19:26, "John K. Hinsdale" <h..._at_alma.com> wrote:
> On Nov 12, 11:32 am,jeremy<jeremy0..._at_gmail.com> wrote:
>
> > We have a requirement to be able to take a .rtf file ...
> > in the database as a BLOB) and do a set of replacements
> > ... Somehow it appears
> > that we are sometimes "corrupting" the RTF
>
> Jeremy, this is what I would do if it were me:
>
> - Find a way to extract the contents of the BLOB column to a file
> prior to the update
> - Do the update (to-CLOB, replace, to-BLOB)
> - Extract the BLOB to a file again under a different name
> - Run a binary diff tool like "bsdiff" and see what changed.
>

Thanks for your response. We identified our problem to be that we were taking as input a BLOB, converting to CLOB, doing character replacements then converting back to BLOB.

When we kept it as BLOB and used utl_raw.cast_to_raw in our dbms_lob.write statements, the problems were solved.

--
jeremy