Re: Temporary LOBs in Oracle not freed up

Now it is, but no difference. But even before, when I created a temp clob for each call, it was properly disposed with dbms_lob.freetemporary()

Bela

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<c4si55$gs6$1_at_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 Tue Apr 06 2004 - 13:51:46 CDT