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
p_output := p_input || p_input;
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.