You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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 ;