Forum: Ruby on Rails Error using mysql store procedures

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
7fb5fbb71c98194e4d63170314aea238?d=identicon&s=25 Thiago (Guest)
on 2006-03-10 22:53
I'm getting this error using mysql store procedure in rails, this is the
error:

Mysql::Error: #0A000PROCEDURE db_dev.sp1 can't return a result set in
the given context: CALL sp1 ('engineer');

In the mysql shell, it works fine, but not in rails. Any thoughts?

Thanks a lot.
7fb5fbb71c98194e4d63170314aea238?d=identicon&s=25 Thiago (Guest)
on 2006-03-11 01:30
Any idea? This is kinda urgent, please. I know this isn't the rails way,
but I need to do it. Thanks


Thiago wrote:
> I'm getting this error using mysql store procedure in rails, this is the
> error:
>
> Mysql::Error: #0A000PROCEDURE db_dev.sp1 can't return a result set in
> the given context: CALL sp1 ('engineer');
>
> In the mysql shell, it works fine, but not in rails. Any thoughts?
>
> Thanks a lot.
This topic is locked and can not be replied to.