Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Temporary LOBs in Oracle not freed up

Re: Temporary LOBs in Oracle not freed up

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 5 Apr 2004 21:13:10 +0000 (UTC)
Message-ID: <c4si55$gs6$1@hercules.btinternet.com>

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...

> 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?
>
Received on Mon Apr 05 2004 - 16:13:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US