Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Temporary LOBs in Oracle not freed up
Is the CLOBVAR a packaged global variable ?
-- Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html April 2004 Iceland http://www.index.is/oracleday.php June 2004 UK - Optimising Oracle Seminar "Bela Vizy" <bvizy_at_cox.net> wrote in message news:BQ4cc.2573$zh.48_at_lakeread01...Received on Mon Apr 05 2004 - 16:13:10 CDT
> Well, the the relevant code I guess is
>
> dbms_lob.createtemporary( clobvar, true);
> ....
>
> Then the next call in the session is
>
> dbms_lob.freetemporary(clobvar);
> dbms_lob.createtemporary( clobvar, true);
>
> The rest is just puuting together the CLOB with dbms_lob.writeappend()
>
> What in particular do you want to know?
>