I am using the Execute stored procedure plugin v1.4.4 on Appian version 18.1 and i am trying to execute a stored procedure in Oracle with 3 IN parameters and 1 OUT parameter which is of type SYS_REFCURSOR.
I have created 3 activity class parameters for the input parameters in the input tab with the exact names and 1 for the OUT parameter which of type list of CDT.
Getting an error saying "There is a problem with task “Execute Stored Procedure” in the process “Export to CSV”. java.sql.SQLException: Invalid column type: 3261" .
3261 is the list of CDT type which has been created for the OAT parameter.
For the above configuration I have gone through the documentation of Execute stored procedure v1.4.6 , not sure if the the configuration done above is incorrect for the v1.4.4.
If anyone could help here please in any way or share the documentation for plugin v1.4.4 ?
Thanks.
Discussion posts and replies are publicly visible
I've definitely had SYS_REFCURSOR returns work on the SP node. I remember often setting parameters as IN OUT in a few scenarios. I know it makes little sense from a PL/SQL perspective but might be worth trying.