title: Clear a DBMS_SQL.VARCHAR2S variable
body: <p>How do we clear out a <code>DBMS_SQL.VARCHAR2S</code> variable so that it can be reused? The declaration goes as below:</p>
  
  <pre><code>DECLARE
     l_updt_stmnt            DBMS_SQL.VARCHAR2S;
  
  BEGIN
     Open LOOP
      l_updt_stmnt(1) := 'some dynamic sql statements';
      &lt;parse the above statement&gt;
     Close LOOP;
  
  EXCEPTION
  WHEN OTHERS THEN
    &lt;Print statement&gt;
  END;
  </code></pre>
  
  <p>I just want to reuse the <code>l_updt_stmnt</code> to generate dynamic sql statements multiple times.</p>
  
  <p>Can anyone help.?</p>