Error in Executing Stored Procedure

A Score Level 1

Hi All,

I am trying to connect a stored procedure in Appian using the Integration Service Execute Stored Procedure. The stored procedure has an output_cursor as an IN OUT parameter named p_in_out_cur which is saving the result of SELECT query. First we made the cursor of type text then it throws an error that ACP p_in_out_cur is a cursor so must be a CDT array, hence we created the cursor of type CDT But it  again throws the error : java.sql.SQLException: Unsupported feature: sqlType=-10

 

Please guide me out for the same. Thanks!!

  Discussion posts and replies are publicly visible