title: SQL Plus SP2-0606
body: <p>Using SQL tool, I want to create a text file that has a VARCHAR records.</p>
  
  <p>Using SQL Developer I have successfully created the output text file by calling a script. But based on my research, the TRIMSPOOl command is currently not supported by SQL Developer, making my output to have trailing spaces.</p>
  
  <p>Here is the code in the script:
      <pre>
      spool on
      set echo off
      set verify off
      set feedback off
      set heading off
      set trimspool on
      set termout off
      spool C:\SQLFiles\Output.txt;
      select cust_name || cust_addr as Cust_Details
      from customer_db;
      spool off;
      </pre></p>
  
  <p>I now have the SQL Plus 11g, and I'm trying to run the script i created in SQL Developer. I'm getting an SP2-0606 error, saying:
      <pre>
      SP2-0606: Cannot create SPOOL file "on.LST:
      </pre></p>
  
  <p>Based on the research I did, it is because of the Spool command, and I don't have the right to access the default folder??.. </p>
  
  <p>Can you help please on what setup I should change do to make the desired result in SQL Plus.</p>