Manipulating LOBs in PL/SQL

From: Izabella <Izabella.Urbanek_at_afp.gov.au>
Date: Tue, 13 Mar 2001 10:46:53 +1100
Message-ID: <98jn37$1lfc$1@platinum.sge.net>

Hi,

I am attempring to concatenate a whole lot of values together to pass to an "execute immediate" statement which will insert a row into the database
(don't ask why!). The values can be strings or CLOBS, therefore I would like
to store them in a local variable of type CLOB.

However, it seems that you can only work on CLOB locators which have been selected from a table. All I want to do is to define a CLOB and work on it
(using dbms_lob.append among others) in a similar way to how I would work
with a string. Is this possible? Has anyone come across this problem and found a solution?

Thanks
Izabella Received on Mon Mar 12 2001 - 17:46:53 CST