Re: Manipulating LOBs in PL/SQL

From: Kirill Paliy <kpaliy_at_aaanet.ru>
Date: Tue, 13 Mar 2001 08:14:09 +0300
Message-ID: <98lp36$1q9h$1@sa.aaanet.ru>

Is dbms_lob.createtemporary unappropriate? This sample works ok

declare
tmp clob;
begin

  dbms_lob.createtemporary(tmp,true);
  dbms_lob.write(tmp,10,1,'1212121212');
  dbms_lob.freetemporary(tmp);

end;

"Izabella" <Izabella.Urbanek_at_afp.gov.au> wrote in message news:98jn37$1lfc$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 Mon Mar 12 2001 - 23:14:09 CST