Hello! I am facing some problems to get OUTPUT values from a StoredProcedure from Oracle using Execute non query.
I used to call the procedures by the CommandType “Text” on the Activity “Execute non query”, this way:
“Begin FL.PROCNAME(‘Param1’, 'Param2); End;”
Here I didn’t used to pass Parameters to the Activity. I used variables to build the String. Everything was working fine.
Happens that the Procedure changed and now I have an OUTPUT parameter.
I tried to change the same Activity property CommandType to “StoredProcedure” and then changed the Sql parameter to the name of the Procedure. I created the input parameters with the same name as the procedure and indicated the Direction OUT on the last one. I’m getting this message now:
String: the Size property has an invalid size of 0
Does anyone knows if I’m doing something wrong or if this is a known problem? On the procedure all parameters are VARCHAR and I’m sending them as String.
Thanks in advance!