title: How do I SPOOL output without reaching buffer limit when setting TERMOUT OFF doesnt work
body: <p>I'm using SQL developer and trying to spool out a fair amount of data. The script stops part way through as the buffer overflow is exceeded.</p>
  
  <p>I understand this is because the Script Output cannot handle this amount of data but the solution to this <code>SET TERMOUT OFF</code> does not work.</p>
  
  <p>I've provided an example below to illustrate this command not working</p>
  
  <pre><code>SET TERMOUT OFF
  /
  
  DECLARE
  
     CURSOR C1 IS
  
     select distinct '1' NUMBERR from dual;
  
  BEGIN
  
  
      for c1_rec in c1 loop
  
      DBMS_OUTPUT.PUT_LINE(C1_REC.NUMBERR);
  
     END LOOP;
  
  end; 
  </code></pre>
  
  <p>Output:</p>
  
  <pre><code>1
  
  
  PL/SQL procedure successfully completed.
  </code></pre>
  
  <p>As you can see, the '1' is still output to the Script Output indicating the SET TERMOUT isn't working</p>