Hi. I have an SQL statement that I am running against an Oracle DB. The statement calls a stored proc on the DB with some IN parameters and OUT parameters. In my microflow when I create the SQL string I can break at that point. copy the generated string, paste it into SQL Developer and run it successfully. If I allow the microflow to run I get an ‘SQLException: Missing IN or OUT parameter at index:: 1’ error. I have no idea how to get round this. Any help appreciated. Thanks.
That error is usually related to query parameters in a java PreparedStatement, are you using the parameter option from the module? Do you happen to have a ? in the query?