# Stored Procedure Group Help **URL:** \ **Category:** Ignition\ **Created:** [March 23, 2010, 5:35pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-group-help/1682 "2010-03-23T17:35:40Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![dep05d](https://avatars.discourse-cdn.com/v4/letter/d/e495f1/32.png) [@dep05d](https://forum.inductiveautomation.com/u/dep05d)\ **Post date:** [March 23, 2010, 5:35pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-group-help/1682/1 "2010-03-23T17:35:40Z")
Hi Everybody, I’m having some trouble trying to create a simple stored procedure group in Ignition build 4594. I have this procedure created in Oracle that outputs the input string twice: CREATE OR REPLACE PROCEDURE ENG.IGNITION\_TEST ( p\_input VARCHAR2, p\_output OUT VARCHAR2) IS BEGIN p\_output := p\_input || p\_input; END IGNITION\_TEST; I have a SP group configured to use a DB Sqltag tied to a text field as p\_input, and I want to write p\_output to a DB Sqltag tied to a Label. A one-shot button is bound to a DB Sqltag that acts as the trigger. When I click the one-shot button, the group errors. I am receiving the error seen in the attached screenshot. I’m guessing I have something configured incorrectly. I’ve tried many different combinations of target/output settings, and the section of the manual on SP groups doesn’t go into too much detail on it. Any help is greatly appreciated. Thanks! Dan ![](https://us1.discourse-cdn.com/inductiveautomation/original/1X/edd12e5ebd5e00d82fa80429d52b21514898bb67.JPG) ---
**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Post date:** [March 23, 2010, 9:27pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-group-help/1682/2 "2010-03-23T21:27:07Z")
Hi- I’m looking into this… it appears that the oracle driver may not support named parameters. I’ll post back soon with more details. Regards, ---
**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Post date:** [March 24, 2010, 5:14pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-group-help/1682/3 "2010-03-24T17:14:34Z")
Ok, well, I’ve looked and looked and tested and tested, and as far as I can tell Oracle should support the method we’re using to pass parameters. However, I can’t get it to work on 10g, and am getting the same error you are. One thing we’ve done that has at least created a work around is to allow specifying parameters by index. So, in your example, p\_input = 0, and p\_output = 1 - with version 7.0.6, you’ll be able to just enter those indexes as parameter names, and it will work. I’m going to keep looking into the name issue, because the oracle docs say it should work… Regards, ---
**Author:** ![dep05d](https://avatars.discourse-cdn.com/v4/letter/d/e495f1/32.png) [@dep05d](https://forum.inductiveautomation.com/u/dep05d)\ **Post date:** [March 24, 2010, 6:18pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-group-help/1682/4 "2010-03-24T18:18:34Z")
Thanks, Colby. We’re attempting to replicate the functionality of the batching component of our legacy system as a proof of concept, so this is definitely a critical component. Do you have an ETA on 7.0.6? Thanks, Dan ---
**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Post date:** [March 24, 2010, 6:23pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-group-help/1682/5 "2010-03-24T18:23:17Z")
We’re hoping sometime very soon, as in tomorrow or friday. We’re waiting for some feedback about an issue we’re having with the internal database… however, I may be able to get you a development version of the SQL Bridge module sooner, which should let you continue. Regards, ---
**Author:** ![dep05d](https://avatars.discourse-cdn.com/v4/letter/d/e495f1/32.png) [@dep05d](https://forum.inductiveautomation.com/u/dep05d)\ **Post date:** [April 1, 2010, 3:29pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-group-help/1682/6 "2010-04-01T15:29:22Z")
Colby, I installed the new version, and the stored procedure groups now work with Oracle when I use the parameter index rather than parameter name. While this is certainly enough to move forward, it would be nice if the issue could be resolved to use the actual parameter name. Some of our procedures have upwards of 25 parameters, so it can get a little confusing! 😃 Thanks again for your help, Dan ---
**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Post date:** [April 1, 2010, 3:57pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-group-help/1682/7 "2010-04-01T15:57:57Z")
I agree, and so we still have the ticket open in our system for improvement in (hopefully) 7.1. We’ll probably have to start by seeing if there’s a new version of the Oracle JDBC driver, since that seems to be where the problem lies… but anyhow, we’ll put some more work into it soon. Regards, ---
**Author:** ![apimente](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/apimente/32/4030_2.png) [@apimente](https://forum.inductiveautomation.com/u/apimente)\ **Post date:** [November 19, 2010, 5:18pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-group-help/1682/8 "2010-11-19T17:18:19Z")
Hi Colby, Today i realize that i’m having the same problem that was described here. To solve it, i used the paramenter index instead of name. Do you have any news about the real solution of this problem. Something about JDBC?. Greetings. ---
**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Post date:** [November 19, 2010, 5:28pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-group-help/1682/9 "2010-11-19T17:28:02Z")
Hi, To be specific- you’re using Oracle as well, right? I’ll have to take a look at whether there’s a new version of the Oracle connector available. Regards, ---
**Author:** ![apimente](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/apimente/32/4030_2.png) [@apimente](https://forum.inductiveautomation.com/u/apimente)\ **Post date:** [November 19, 2010, 8:29pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-group-help/1682/10 "2010-11-19T20:29:39Z")
Yes, I’m using the 10 XE edition and the JDBC driver that is included with IGNITION. At the time, my procedure works fine but using the index of parameters instead name. ---
**Author:** ![apimente](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/apimente/32/4030_2.png) [@apimente](https://forum.inductiveautomation.com/u/apimente)\ **Post date:** [November 26, 2010, 12:53pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-group-help/1682/11 "2010-11-26T12:53:43Z")
Dear Friends, Today i downloaded the Oracle JDBC driver (for Oracle 10g 10.2.0.4) and everything works fine. It looks like that was the problem. So now i can execute stored procedures indicating the name of parameters and not the index of it. Greetings.