title: how to connect to sqlplus using perl script
body: <p>In unix the normal procedure that we use to connect to sqlplus is like this</p>
  
  <pre><code>sqlplus ${user}/${password}@${server} my_file.sql &gt;&gt; $Logfile 2&gt;&amp;1
  </code></pre>
  
  <p>where im appending all the info in the above command  to the log file <code>$Logfile</code></p>
  
  <p>Now in perl i know how to connect to sqlplus and execute a sql script i used something like</p>
  
  <pre><code>system("sqlplus -L ${user}/${password}@${server} my_file.sql")
  </code></pre>
  
  <p>but using <code>system</code> we cannot send an info to a log file it will only give the return status i want to track the info of the executed command like we do in unix Is there a way to do this. Please help Thanks</p>