DBMS_LOB and memory management
fcjunicJan 12 2012 — edited Jan 31 2012Hello all,
When I declare a CLOB variable (myclob) do I always have to free it with dbms_lob.freetemporary(myclob) at the end of my procedure ?
I know I have to free it if it was created with dbms.createtemporary(myclob,....) but what happens when I run statements like "SELECT to_clob('Test') INTO myCLOB FROM DUAL;"
I don't find in Oracle documentation a good answer to this question ! Can someone explain the difference ? I hope memory is freed correctly without having to explicitly do a "freetemporary" but I'm not sure !
Thanks for your answers !