# Running a stored procedure in an Oracle DB

**URL:** <https://discourse.nodered.org/t/running-a-stored-procedure-in-an-oracle-db/16167>\
**Category:** General\
**Created:** [1 October 2019 18:40 UTC](https://discourse.nodered.org/t/running-a-stored-procedure-in-an-oracle-db/16167 "2019-10-01T18:40:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![nazHossain0316](https://avatars.discourse-cdn.com/v4/letter/n/9fc348/32.png) [@nazHossain0316](https://discourse.nodered.org/u/nazHossain0316)\
**Post date:** [1 October 2019 18:40 UTC](https://discourse.nodered.org/t/running-a-stored-procedure-in-an-oracle-db/16167/1 "2019-10-01T18:40:14Z")

</div>

I want to preference this by saying that I'm a complete novice in Node-Red, javascript, and the coding world in general. Currently, I am trying to run a stored procedure on the oracledb node but am greeted with an error: "Oracle query error: NJS-019: ResultSet cannot be returned for non-query statements" .

Would anyone be able to point me in the right direction here? Thanks in advance

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [1 October 2019 18:54 UTC](https://discourse.nodered.org/t/running-a-stored-procedure-in-an-oracle-db/16167/2 "2019-10-01T18:54:18Z")

</div>

some idea of your flow might be useful?