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

Home -> Community -> Usenet -> c.d.o.server -> Working with BLOBS

Working with BLOBS

From: Jeremy <newspostings_at_hazelweb.co.uk>
Date: Mon, 10 Nov 2003 18:17:47 -0000
Message-ID: <MPG.1a19e69ed9ca383d989939@news.individual.net>


Hi - PL/SQL Oracle 8i (8.1.7)

We have a document stored in a BLOB. We know this is an RTF (rich text format) and it contains 'placeholders' (e.g. [last_name] which we then wish to substitute with the person's name).

So we read the BLOB into a PL/SQL block - what is the most efficient/easiest way of performing our string replacements?

If it were in a varchar2, we could simply say

  l_doc := replace(l_doc,'[last_name]',l_last_name);

Is there an equivalent with BLOBS? Or do I need to read it in chunks into a varchar2, process it and then reassemble it as a new BLOB?

Thanks for any pointeres here....

-- 

jeremy
Received on Mon Nov 10 2003 - 12:17:47 CST

Original text of this message

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