Execute Stored Procedure Error

Question

Hi, 
 
 I am trying to execute a stored procedure through function and smart service as well. But getting below error. 
 Function Body: 
 with(local!spResult: fn!executestoredprocedure("jdbc/BusinessDS","GETData", { {name: "in_id", value: 3270}} ), local!spResult) 
 Error: j ava.sql.SQLException: Unsupported feature: sqlType=-10 
 The Appian version we are using is 18.4 and Oracle version is 12c 
 Thanks in advance

yogeshd149 · Answer

Hi , 
 The issue is resolved for me. In the stored procedure defination, the Out paramter should only be defined as "OUT" and not as "IN OUT". It seems Oracle does not support that syntax. 
 
 Thanks & Regards, 
 Yogesh Dhake

yogeshd149 · Answer

Hi , 
 The issue is resolved for me. In the stored procedure definition, the Out paramter should only be defined as "OUT" and not as "IN OUT". It seems Oracle does not support that syntax. 
 
 Thanks & Regards, 
 Yogesh Dhake