Posted: 13 Feb 2018 15:22 EST Last activity: 14 Feb 2018 23:15 EST
OracleQuery Output parameter returns BLANK
We have a OracleQuery control that invokes stored procedure which has 2 out parameters. Somehow OracleQuery always returns blank out parameter results even stored procedure has results. Attached doc has the code and sp details
If it's returning blank, then there is no data being pushed out. If it's returning NULL, that's a different matter and might be a problem. You can check what data is being pushed out by setting a breakpoint in the automation and walking through it one step at a time.