Hello All,
I am trying to execute a storedprocedure using fn!executestoredprocedure in SAIL interface, but it is not executing and throwing some error as below.
Note: I am facing this issue for only this SPROC in one environment and rest of SPROCS are executing fine irrespective of environments.
with( local!spResult: fn!executestoredprocedure( "jdbc/PRSDEVAppian", "sp_GetReportCountByUserID", { name: "inUserID", value: ri!userId }, { name: "inReportType", value: 2 } ), local!spResult)
Output:
Dictionary :
success: false
error: "java.lang.ClassCastException "
==================================
Expected Output/Working output in other environments:
Dictionary
success: true
error: null (Text)
parameters:
Dictionary inReportCount: 162
result: List of Variant: 0 items
Please share your thoughts on this. Thank you.
Discussion posts and replies are publicly visible