title: how can i pass information from ant to sql file or procedure
body: <p>i am creating a user by using ant target as below </p>
  
  <pre><code>&lt;target name="create_user"&gt;
       &lt;exec executable="sqlplus" dir="${basedir}/dbsetup"&gt;
            &lt;arg value="system/oracle@orcl"/&gt;
            &lt;arg value="@create_user.sql"/&gt;
       &lt;/exec&gt;    
  &lt;/target&gt;
  </code></pre>
  
  <p>and the sql files is as follows........</p>
  
  <pre><code>create user test identified by password;
  
  grant resource, connect to test ;
  
  grant create view to test ;
  
  grant create materialized view to test ;
  
  grant create sequence to test ;
  
  grant create procedure to test ;
  
  grant create any directory to test ;
  
  grant create database link to test ;
  
  alter user test  quota unlimited on users; 
  
  quit;
  </code></pre>
  
  <p>At present the user name is hard coded in <code>create_user.sql</code>
  Now i want to prompt for user name and password from ant and pass to sql file.</p>
  
  <p>Please advice how can i achieve this or some other way by which i can achieve</p>