# Stored Procedures error 500

**URL:** <https://community.dreamfactory.com/t/stored-procedures-error-500/1115>\
**Category:** REST API\
**Created:** [May 19, 2015, 6:54am UTC](https://community.dreamfactory.com/t/stored-procedures-error-500/1115 "2015-05-19T06:54:52Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**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:** [May 19, 2015, 4:30pm UTC](https://community.dreamfactory.com/t/stored-procedures-error-500/1115/2 "2015-05-19T16:30:13Z")

</div>

Likely this is a difference between the driver behavior in Windows and \*nix (different drivers are used between those environments). Typically [it’s been noticed](https://community.dreamfactory.com/t/db-how-could-call-a-db-function/447/11?u=jeffreystables) that DSP will throw an error if a SPROC returns no values. The best way to resolve this would be to edit your SPROC to return a value, even just a dummy one, so DSP knows the procedure was executed successfully.

---

_[View the full topic](https://community.dreamfactory.com/t/stored-procedures-error-500/1115)._