# Logstash cannot call SQL Stored Procedure

**URL:** https://discuss.elastic.co/t/logstash-cannot-call-sql-stored-procedure/44271
**Category:** Logstash
**Created:** [March 14, 2016, 1:35am UTC](https://discuss.elastic.co/t/logstash-cannot-call-sql-stored-procedure/44271 "2016-03-14T01:35:46Z")
**Posts on this page:** 1
**Showing post:** 13

<div class="post-metadata">

### Author: ![Exocomp](https://avatars.discourse-cdn.com/v4/letter/e/ea5d25/32.png) [@Exocomp](https://discuss.elastic.co/u/Exocomp)
#### Post date: [May 9, 2017, 1:08pm UTC](https://discuss.elastic.co/t/logstash-cannot-call-sql-stored-procedure/44271/13 "2017-05-09T13:08:32Z")

</div>

@Ashish_Viradia

I found this to be a bug, if you run logstash in debug mode the jdbc plugin will do a SELECT TOP(1) on the stored procedure which is invalid.

However, if logstash is not in debug mode then it works fine. Not the best solution but at least a work around.

E

---

_[View the full topic](https://discuss.elastic.co/t/logstash-cannot-call-sql-stored-procedure/44271)._