# Stored Procedure call returns Code 500 with Response Body: no content **URL:** \ **Category:** REST API\ **Created:** [November 12, 2014, 4:30am UTC](https://community.dreamfactory.com/t/stored-procedure-call-returns-code-500-with-response-body-no-content/544 "2014-11-12T04:30:14Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![geomos](https://avatars.discourse-cdn.com/v4/letter/g/b9bd4f/32.png) [@geomos](https://community.dreamfactory.com/u/geomos)\ **Post date:** [November 12, 2014, 4:30am UTC](https://community.dreamfactory.com/t/stored-procedure-call-returns-code-500-with-response-body-no-content/544/1 "2014-11-12T04:30:14Z")
I make a stored procedure call to a MySQL db using the REST API. It works fine when the result set has a small number of rows to return. However when the result dataset is larger I get Response Code **500** with Response Body: **no content**. Testing the same stored procedure call via a db client, it works fine and I get the result of the stored procedure call. I tested REST API’s stored procedure call with several different stored procedures (with and without parameters) and I get the same behavior (no content in the body even if the stored procedure works fine). What could be the reason for that? I used both versions 1.7.8 and 1.8 and got the same results. ---
**Author:** ![toddappleton](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/toddappleton/32/159_2.png) [@toddappleton](https://community.dreamfactory.com/u/toddappleton)\ **Post date:** [November 12, 2014, 2:07pm UTC](https://community.dreamfactory.com/t/stored-procedure-call-returns-code-500-with-response-body-no-content/544/2 "2014-11-12T14:07:21Z")
If you haven’t already, try calling the stored procedure from the API Docs in the DSP admin console. Just curious to see if you get the same result there. ---
**Author:** ![geomos](https://avatars.discourse-cdn.com/v4/letter/g/b9bd4f/32.png) [@geomos](https://community.dreamfactory.com/u/geomos)\ **Post date:** [November 12, 2014, 2:51pm UTC](https://community.dreamfactory.com/t/stored-procedure-call-returns-code-500-with-response-body-no-content/544/3 "2014-11-12T14:51:07Z")
I did try to call the stored procedures from API Docs in the DSP admin console and I am getting the same response (no content). I believe It is not specific to a single stored procedure (tested with a few different ones) and I am still getting “no content” when the procedure returns a few hundred rows back. My configuration: Using the Bitnami distribution (1.7.8 and 1.8) and MySQL. ---
**Author:** ![toddappleton](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/toddappleton/32/159_2.png) [@toddappleton](https://community.dreamfactory.com/u/toddappleton)\ **Post date:** [November 12, 2014, 6:25pm UTC](https://community.dreamfactory.com/t/stored-procedure-call-returns-code-500-with-response-body-no-content/544/4 "2014-11-12T18:25:31Z")
I created a stored procedure on my 1.8.0 OS X Bitnami install that does a select on a single table of 1300 records. ``` BEGIN SELECT * FROM contact; END ``` It worked fine. Have you tried a really simple one like this? Care to post your stored procedure so we can see it? ---
**Author:** ![geomos](https://avatars.discourse-cdn.com/v4/letter/g/b9bd4f/32.png) [@geomos](https://community.dreamfactory.com/u/geomos)\ **Post date:** [November 15, 2014, 5:03am UTC](https://community.dreamfactory.com/t/stored-procedure-call-returns-code-500-with-response-body-no-content/544/5 "2014-11-15T05:03:41Z")
I did try with a simple select: CREATE PROCEDURE cube\_survey.`test`() BEGIN select \* FROM fact\_aggreegates\_view\_stage; END; I get the same “no content” response. The table has about 700K rows. Here is the table description: CREATE TABLE `fact_aggreegates_view_stage` ( `id` int(11) NOT NULL DEFAULT ‘0’, `DIM_SURVEY_id` int(11) NOT NULL, `DIM_TIME_id` int(11) NOT NULL, `DIM_STATE_id` int(11) NOT NULL, `DIM_INDUSTRY_id` int(11) NOT NULL, `DIM_SIZE` int(11) DEFAULT NULL, `DIM_ANSWERS_id` int(11) NOT NULL, `total_count` int(11) DEFAULT NULL, `total_percent` double DEFAULT NULL, `load_date` datetime DEFAULT NULL, `time_year` int(11) DEFAULT NULL, `time_quarter` int(11) DEFAULT NULL, `time_quarter_short` char(3) DEFAULT NULL, `time_quarter_long` char(15) DEFAULT NULL, `time_month` int(11) DEFAULT NULL, `time_month_short` char(3) DEFAULT NULL, `time_month_long` char(10) DEFAULT NULL, `state` varchar(2) DEFAULT NULL, `state_region_id` int(11) DEFAULT NULL, `state_region` varchar(45) DEFAULT NULL, `industry_short` varchar(100) DEFAULT NULL, `industry_long` varchar(200) DEFAULT NULL, `employeesize` varchar(45) DEFAULT NULL, `resp_qcode` char(10) DEFAULT NULL, `resp_q_short` varchar(100) DEFAULT NULL, `resp_q` varchar(300) DEFAULT NULL, `resp_acode` int(11) DEFAULT NULL, `resp_a_short` varchar(100) DEFAULT NULL, `resp_a` varchar(200) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; Calling the procedure from the API Docs is not working (returns Error 500 - no content). Calling getRecords() from the table directly works fine. Strange. ---
**Author:** ![toddappleton](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/toddappleton/32/159_2.png) [@toddappleton](https://community.dreamfactory.com/u/toddappleton)\ **Post date:** [November 15, 2014, 2:20pm UTC](https://community.dreamfactory.com/t/stored-procedure-call-returns-code-500-with-response-body-no-content/544/6 "2014-11-15T14:20:12Z")
Do you really need to return 700K records to the client? That’s a lot of data. Based on your previous post I thought you were talking about hundreds of records not hundreds of thousands. getRecords in the API docs only returns the first page of 1000 records so that’s why it worked. Stored procedures return all the data in one response. ---
**Author:** ![geomos](https://avatars.discourse-cdn.com/v4/letter/g/b9bd4f/32.png) [@geomos](https://community.dreamfactory.com/u/geomos)\ **Post date:** [November 20, 2014, 4:44am UTC](https://community.dreamfactory.com/t/stored-procedure-call-returns-code-500-with-response-body-no-content/544/7 "2014-11-20T04:44:03Z")
Even if I filter the table in the stored procedure the Rest API still returns “No content” using the callStoredProc(). The result set is just 1300 [rows.In](http://rows.In) another stored procedure it would work with 96 rows but it will not work with 144 rows. ---
**Author:** ![rakeshdebur](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/rakeshdebur/32/187_2.png) [@rakeshdebur](https://community.dreamfactory.com/u/rakeshdebur)\ **Post date:** [December 16, 2014, 11:27am UTC](https://community.dreamfactory.com/t/stored-procedure-call-returns-code-500-with-response-body-no-content/544/8 "2014-12-16T11:27:27Z")
Hi. Were you able to solve this problem. If so, can you please post the solution. I am facing the same problem with Oracle 11g database. I am able to connect to it from a php code but not via rest api. ---
**Author:** ![jeffreystables](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/jeffreystables/32/173_2.png) [@jeffreystables](https://community.dreamfactory.com/u/jeffreystables)\ **Post date:** [December 22, 2014, 5:47pm UTC](https://community.dreamfactory.com/t/stored-procedure-call-returns-code-500-with-response-body-no-content/544/9 "2014-12-22T17:47:10Z")
Hi @rakeshdebur, are you certain for your Oracle connection you’re receiving the same Response Code 500 with Response Body: no content as the topic in this thread?