title: Call to a stored procedure in Rails 4
body: <p>I am calling a stored procedure that returns several results. </p>
  
  <p>In Rails 4, the only solution found is to initiate a new <code>Mysql2::Client</code> with the flag MULTI_STATEMENTS. It seems not right to me to open a new connection to the database server. </p>
  
  <pre><code>options = Rails.application.config_for(:database).merge flags: Mysql2::Client::MULTI_STATEMENTS
  client = Mysql2::Client.new options
  results = client.query %Q{CALL my_proc('#{params}')}
  client.close
  
  results
  </code></pre>
  
  <p>So my question: is there a better solution as of now?</p>