title: Calling os_command.exec from an Oracle stored procedure
body: <p>I have used <code>os_command.exec</code> to send commands to the Linux shell. I am using Oracle 12c.</p>
  
  <p>Here is an example code which works fine:</p>
  
  <pre><code>select os_command.exec('/home/smucha/app/smucha/product/12.1.0/dbhome_1/bin/sqlldr userid=system/password control=/home/smucha/load_data.cmt')
  from dual
  </code></pre>
  
  <p>I would like to run a similar command in a stored procedure. Is there any way to do this?</p>
  
  <p>I have tried the following but it does not work. My procedure runs without errors but no records are loaded.</p>
  
  <pre><code>execute immediate 'select os_command.exec(''/home/smucha/app/smucha/product/12.1.0/dbhome_1/bin/sqlldr userid=system/acorp56k control=/home/smucha/IZ/load_data.cmt'') from dual';
  </code></pre>