Activity Execute non query - Erros to get OUTPUT parameters when calling an StoredProcedure

Help
,
1

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[6]: 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!

2

Please, send the workflow

3

Oracle - Execute Query - Example.xaml (14.8 KB)

As peer requested, here’s an example of Working Code (Without OUTPUT parameters) and Not Working Code (With OUTPUT parameters).