Error using mysql store procedures


#1

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.


#2

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.