1

I´m using Oracle 11gR2, can someone tell me why the temporary lob isn´t freed?

    ... 
    -- Apply stylesheet to DOM document
    outdomdocf := dbms_xslprocessor.processxsl(proc, xsl, indomdoc);
    outnode := dbms_xmldom.makenode(outdomdocf);

    -- Write the transformed output to the CLOB
    dbms_lob.createTemporary(outfile, true, DBMS_LOB.CALL);
    dbms_xmldom.writetoCLOB(outnode, outfile);

    -- Free Cursors
    outXML := XMLTYPE.createXml(outfile);
    dbms_lob.freeTemporary(outfile);            <-- not working
    ...

When I do 

select * from v$temporary_lobs;

It´s still there.

Vadim Kotov
  • 8,084
  • 8
  • 48
  • 62
chris
  • 600
  • 7
  • 21

1 Answers1

2

you need DBMS_LOB.CLOSE() to close it before calling DBMS_LOB.FREETEMPORARY() .

nmc
  • 8,724
  • 5
  • 36
  • 68
burnDB
  • 54
  • 2