Hi,
I have an performance issue in my inner join so i used Stored procedure
its working fast and fine but i am unable to call that from my ruby on
rails (2.3.2) projects.I am getting error “Mysql::Error: PROCEDURE
Work.Get_Report_By_Date can’t return a result set in the given context”
Below is my Stored Procedure code
DELIMITER $$
DROP PROCEDURE IF EXISTS `Work`.`Get_Report_By_Date`$$
CREATE DEFINER=`root`@`%` PROCEDURE `Get_Report_By_Date`()
BEGIN
SELECT * FROM schedules;
END$$
DELIMITER ;
In mysql its working fine.
my Rails code
CallStoredProcedures.fetch_db_records(“Get_Report_By_Date();”);
I got reference from the below URL. But it doesn’t help me
http://nasir.wordpress.com/2007/12/04/s … ls-part-2/
Can any one help me?