title: Issue in Calling Stored Procedure from Shell Script
body: <p>I have a stored procedure <code>cleanRecords</code> in mysql database which modifies data in a table <code>dailyRecordLog</code>. </p>
  
  <p>I am calling stored procedure <code>cleanRecords</code>after executing <code>MySQL DATA LOADER</code>. </p>
  
  <p>The calls are initiated from a shell script <code>loadDataToDB.sh</code> as follows:</p>
  
  <ol>
  <li><p>Shell script calls <code>MySQL DATA LOADER</code> to load data into <code>dailyRecordLog</code> table from a flat file. (records status are <code>pending cleanup</code>)</p></li>
  <li><p>Shell script then calls <code>cleanRecords</code> stored procedure to clean records. 
  (records status are <code>cleanup success</code> / <code>cleanup failed</code>).</p></li>
  </ol>
  
  <p>I am facing following issue:</p>
  
  <ul>
  <li><p>When I call <code>loadDataToDB.sh</code> records get loaded and final status is <code>cleanup success</code> but when I go to database, I see that records are actually not cleaned up. That is execution is partially successful. </p></li>
  <li><p>When I call <code>cleanRecords</code> from MySQL prompt on a data set already available in database, I see a completely successful execution. </p></li>
  </ul>
  
  <p>I have verified this behavior multiple times and I have no clue why call initiation from shell script results in partial success. </p>