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 -> Must one free Temp LOB ?

Must one free Temp LOB ?

From: Ed <ed_at_mail.com>
Date: Wed, 7 Mar 2007 17:30:04 -0500
Message-ID: <12uuf7ddf94s3a7@corp.supernews.com>


10gR2
Given I have these 2 procs below, "use_clob" and "make_clob" In which one should I free the temp LOB ? and is this done via "DBMS_LOB.FREETEMPORARY" ?

thanks

PROCEDURE make_clob (p_out_clob OUT CLOB) IS
BEGIN
----snip--------

END ; PROCEDURE use_clob
IS
l_temp_clob CLOB ;
BEGIN
  ----snip--------
FOR i in 1..300
 LOOP
  make_clob(l_temp_clob) ;
----snip--------

END LOOP;
----snip--------

END ; Received on Wed Mar 07 2007 - 16:30:04 CST

Original text of this message

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