# How to call a store proc with parameters via JBDC input plugin on Logstash?

**URL:** <https://discuss.elastic.co/t/how-to-call-a-store-proc-with-parameters-via-jbdc-input-plugin-on-logstash/129268>\
**Category:** Logstash\
**Created:** [April 24, 2018, 9:10am UTC](https://discuss.elastic.co/t/how-to-call-a-store-proc-with-parameters-via-jbdc-input-plugin-on-logstash/129268 "2018-04-24T09:10:53Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Achilles\_Ka](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/achilles_ka/32/30388_2.png) [@Achilles\_Ka](https://discuss.elastic.co/u/Achilles_Ka)\
**Post date:** [April 24, 2018, 9:10am UTC](https://discuss.elastic.co/t/how-to-call-a-store-proc-with-parameters-via-jbdc-input-plugin-on-logstash/129268/1 "2018-04-24T09:10:53Z")

</div>

Hi all,  
Is there any example of how to call a store proc with parameters for SQL Server via JDBC plugin?  
I tried a couple of different implementations using "statement\_filepath" as well as "statement" properties but no luck so far. Can anyone help by showing what is the proper syntax for passing parameters on store proc? I'm using 6.2.2 ELK stack and SQL Server 2016.  
Thanks in advance!

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [April 24, 2018, 10:11am UTC](https://discuss.elastic.co/t/how-to-call-a-store-proc-with-parameters-via-jbdc-input-plugin-on-logstash/129268/2 "2018-04-24T10:11:45Z")

</div>

> <https://github.com/logstash-plugins/logstash-input-jdbc/issues/99>

---

<div class="post-metadata">

**Author:** ![Achilles\_Ka](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/achilles_ka/32/30388_2.png) [@Achilles\_Ka](https://discuss.elastic.co/u/Achilles_Ka)\
**Post date:** [April 24, 2018, 2:25pm UTC](https://discuss.elastic.co/t/how-to-call-a-store-proc-with-parameters-via-jbdc-input-plugin-on-logstash/129268/3 "2018-04-24T14:25:38Z")

</div>

Thank you Magnus!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [May 22, 2018, 2:25pm UTC](https://discuss.elastic.co/t/how-to-call-a-store-proc-with-parameters-via-jbdc-input-plugin-on-logstash/129268/4 "2018-05-22T14:25:39Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.