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. -- Posted via ruby-forum.com.
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.-- Posted via ruby-forum.com.