Ruby on Rails

Hi All,

Suppose I have a stored procedure named procedure().

Running ActiveRecord::Base.connection.execute("CALL procedure()") will
give you a bunch of errors in different cases while using mysql2 adapter
like:

ActiveRecord::StatementInvalid: Mysql2::Error: PROCEDURE can't return a
result set in the given context: procedure() PROCEDURE

or

ActiveRecord::StatementInvalid: Mysql2::Error: Commands out of sync; you
can't run this command now.

How can The problem be solved? Need Assistance.


Best Regards,

Nirmalya Ghosh

--
Posted via http://www.ruby-forum.com/.

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/9061604e442ce5b36e98f493954dcb40%40ruby-forum.com.
For more options, visit https://groups.google.com/d/optout.