title: Do I need to deallocate a clob variable in Oracle PL/SQL function?
body: <p>I had used a clob variable for creating some large XML in PL/SQL function. The function returns this CLOB variable.
  Will this cause any performance degradation or memory issue?</p>
  
  <p>Sample Code:</p>
  
  <pre><code>FUNCTION ABC
     RETURN CLOB
  IS
     resultxml   CLOB;
  BEGIN
     resultxml := TO_CLOB (' ');
  
     DBMS_LOB.writeappend (resultxml,
                           LENGTH ('---Some large data-'),
                           '---Some large data-');
  
     RETURN resultxml;
  END;
  </code></pre>
  
  <p>Am not facing any issue right now, but want to check out whether it could create mem. issues.</p>