title: PROCEDURE can't return a result set in the given context
body: <p>In rails(3.2.1, mysql2) app, i want to call and show results from a procedure 
  I google and tried diff ways, but no luck, issue is still the same here is code snipet i am using to call the procedure </p>
  
  <pre><code>ActiveRecord::Base.connection.execute("call sp_name(1,10)")
  </code></pre>
  
  <p>below is the error i get on executing this code</p>
  
  <pre><code>Mysql2::Error: PROCEDURE sp_name can't return a result set in the given      
  context: call sp_name(1, 10)
  ActiveRecord::StatementInvalid: Mysql2::Error: PROCEDURE sp_name can't    
  return a result set in the given context: call user_childs(1, 10)
  from /home/ankit/.rvm/gems/ruby-1.9.2-p290/gems/activerecord-  
  3.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:233:in `query'
  from /home/ankit/.rvm/gems/ruby-1.9.2-p290@sharetok/gems/activerecord-3.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:233:in `block in execute'
  from /home/ankit/.rvm/gems/ruby-1.9.2-p290/gems/activerecord-3.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
  from /home/ankit/.rvm/gems/ruby-1.9.2-p290/gems/activesupport-3.2.1/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
  from /home/ankit/.rvm/gems/ruby-1.9.2-p290/gems/activerecord-3.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
  from /home/ankit/.rvm/gems/ruby-1.9.2-p290/gems/activerecord-3.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:233:in `execute'
  from /home/ankit/.rvm/gems/ruby-1.9.2-p290/gems/activerecord-3.2.1/lib/active_record/connection_adapters/mysql2_adapter.rb:214:in `execute'
  </code></pre>