Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Must one free Temp LOB ?

0 views
Skip to first unread message

Ed

unread,
Mar 7, 2007, 5:30:04 PM3/7/07
to
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 ;

0 new messages