Re: Manipulating LOBs in PL/SQL

declare
v_newlob clob;
begin
insert into lobtab (key, clob_col) values (1,empty_clob()) returning clob_col into v_newlob;
-- do processing e.g.
dbms_lob.append (v_newlob, ....)

hth

Klaus
Izabella <Izabella.Urbanek_at_afp.gov.au> schrieb in im Newsbeitrag: 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 Wed Mar 14 2001 - 08:37:50 CST