Post any question you may have in regards to GoAnywhere MFT and let our talented support staff and other users assist you.
- Posts: 1
- Joined: Tue Jan 17, 2017 4:49 pm
I have requirement : Call stored procedure, it has 1 IN parameter and 3 OUT parameters. Based on OUT parameter value i need to implement logic.
using following code to call Stored procedure:
I have created outVariable for this SQL query, but it doesn't have out parameter values. I just returning number of rows affected (-1 or 1 etc)
Can anyone help me out to get rid of this issue.
- Posts: 592
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
The In/Out variables do not work that way through the JDBC connection.
You will need to write the "out" values into a temp table or CSV, then read them (select * from tempTable) or ReadCSV task from within your Project to return those values to your Project.
Lead Solutions Consultant
Return to “Community Forum”