Invalid column type: 1111 with Execute Store Procedure

Certified Senior Developer
Hi All,

I am getting issue while running fn!executestoredprocedure Appian function.While trying to call the executestoredprocedure, While testing the rule ,I get the error:
Invalid column type: 1111

I am facing the same issue with "Execute Stored procedure" smart service also,it shows the error message as follows:
There is a problem with task “Execute Stored Procedure” in the process “Test_SP”. java.sql.SQLException: Invalid column type

In the stored procedure I am using 2 parameters with 1st being In parameter which takes input and 2nd being out parameter which is table valued parameter.

I have given schema name along with procedure name and also provided the correct column name as input parameter

Please kindly provide solution for this issue. Thanks in Advance

OriginalPostID-255354


executedStoreProcedure code.txt

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Senior Developer
    @ramanjaneyulut- In the stored procedure (Oracle db), I checked the input parameter it is fine, I have out parameter of type package object. For example GETTRTDETAIL(PackageNo IN VARCHAR2,Package_Tab OUT package_obj)
    When Out parameter is of type package object, it shows Invalid Column Type 1111. When I remove the out parameter, it return {}.I guess issue is with out parameter
    But I need to have out parameter of type object to return multiple column values.
    How to retrieve this out parameter or any other alternative solution?
Reply
  • 0
    Certified Senior Developer
    @ramanjaneyulut- In the stored procedure (Oracle db), I checked the input parameter it is fine, I have out parameter of type package object. For example GETTRTDETAIL(PackageNo IN VARCHAR2,Package_Tab OUT package_obj)
    When Out parameter is of type package object, it shows Invalid Column Type 1111. When I remove the out parameter, it return {}.I guess issue is with out parameter
    But I need to have out parameter of type object to return multiple column values.
    How to retrieve this out parameter or any other alternative solution?
Children
No Data