# Mysql Database Storeprocdure

**URL:** <https://www.ruby-forum.com/t/mysql-database-storeprocdure/180044>\
**Category:** Rails\
**Created:** [December 10, 2009, 8:20am UTC](https://www.ruby-forum.com/t/mysql-database-storeprocdure/180044 "2009-12-10T08:20:40Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![periyasamy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/3d9bf3/32.png) [@periyasamy](https://www.ruby-forum.com/u/periyasamy)\
**Post date:** [December 10, 2009, 8:20am UTC](https://www.ruby-forum.com/t/mysql-database-storeprocdure/180044/1 "2009-12-10T08:20:40Z")

</div>

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  
[Stored Procedures and Rails – Part 2 – Nasir Jamal](http://nasir.wordpress.com/2007/12/04/s) … ls-part-2/

Can any one help me?