ruby-on-rails - ActiveRecord::StatementInvalid (Mysql::Error: PROCEDURE db_name.proc_spName can't return a result set in the given context:

Question

我已经使用 activerecord 从数据库访问数据。它在本地主机上运行良好，但是当我在另一台服务器上尝试时，出现以下错误:

ActiveRecord::StatementInvalid (Mysql::Error: PROCEDURE db_name.proc_spName can't return a result set in the given context: CALL proc_spName(............)):
    /vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:188:in `log'
    /vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:310:in `execute'
    /app/controllers/keywordprocessor_controller.rb:306:in `result'
    /vendor/rails/actionpack/lib/action_controller/base.rb:1256:in `send'

顺便说一句，下面是我收到以下错误的行

sql = "CALL proc_getresults"
res = ActiveRecord::Base.connection.execute(sql)

任何想法将不胜感激..

Answer 1

正如 BJG 向您展示的那样，该链接几乎可以解释它；因为 ActiveRecord 期望返回一个结果集。您可以沿着这些路线使用一些东西来使用 execute 调用存储过程。

 SELECT proc_getresults() as Results FROM TABLE ...