Displaying 1 result from an estimated 1 matches for "testsp".
Did you mean:
tests
2006 Mar 28
2
Mysql stored procedures from Rails
...all,
I know stored procedures are considered evil around, but there are times
when you just have to use them. In the project I''m working on, I needed
to call a mysql5 stored procedure, but I only got an error message
saying "ActiveRecord::StatementInvalid: Mysql::Error: PROCEDURE
vc.testsp can''t return a result set in the given context: call testsp()"
I found out from here: http://bugs.mysql.com/bug.php?id=2658 that mysql
needs the flag CLIENT_MULTI_RESULTS set if you want to be able to return
result sets from stored procedures. The problem is that mysql_adapter.rb
does...