Rails - Mar 2006 - Error using mysql store procedures

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 http://www.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 http://www.ruby-forum.com/.