Re: Manipulating CLOBs in PL/SQL

You must create the local clob after you declare it. Declaring a clob in the DECLARE section does not allocate the space or a locator. You can create the clob for either the length of the call or for the life of the session. Unless you are going to pass the clob around, you should make it only for a call.

For example,

l_clobvar CLOB
BEGIN
.......
DBMS_LOB.CREATETEMPORARY(l_clobvar,TRUE,DBMS_LOB.CALL);

See the documentation on DBMS_LOB.

"Izabella" <Izabella.Urbanek_at_afp.gov.au> wrote in message news:98jnhh$1lj2$1_at_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 Wed Mar 14 2001 - 21:53:08 CET