title: spooling an sqlplus query without prompted variable text
body: <p>I have an sql file in which I prompt the user for a variable using &amp; sign and running the query with sqlplus accordingly. It spools the output to a txt file.</p>
  
  <pre><code>select * from ledger_line where order_no=&amp;order_no;
  </code></pre>
  
  <p>I am not putting the whole script here. When I run this, the text prompting the user with value also displayed just before the output lines. I want only the answerset to be displayed. verify off, feedback off didn't work. Also running the sqlplus in silent mode with -s is no use.<br></p>
  
  <p>command line:<br></p>
  
  <pre><code>SQL&gt; @D:/deneme.sql
  Connected.
  Enter value for order_no: 99
  </code></pre>
  
  <p>Output txt:<br></p>
  
  <pre><code>Enter value for order_no: 99
  Büro Malzeme Gideri      000001 S 0077030720 81 0077030720         0.90   TRY                                     
  TicBrçlr-MG/FG-MMGid     000002 S 0032000103 96 0032000103         0.90 - TRY                             0,90          
  </code></pre>
  
  <p>Any ideas?</p>