Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Must one free Temp LOB ?
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
![]() |
![]() |