title: How to pass parameter values from batch (.bat) file to sql file
body: <p>I am trying to run one sql file from windows batch file with userid, password and a third parameter value as input. </p>
  
  <p>From command line I am running this--> <strong>D:\ testmyFolder> mytestbat.bat MYUSER MYPASSWRD INPARAM</strong></p>
  
  <p>My batch file (D:/testmyFolder/mytestbat.bat) content is as follows: </p>
  
  <pre><code>SET USRID=%1 
  SET PWD=%2 
  SET INPUT1=%3 
  SQLPLUS %USRID%/%PWD% @testmy.sql %USRID% %PWD% %INPUT1%&gt;D:/testmyFolder/Log/testmylog.Log;
  </code></pre>
  
  <p>I am not able to run this... Its just opening up the sql file...
  Could anyone please help??</p>