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: java.sql.SQLException: Unsupported feature: sqlType=-10
The Appian version we are using is 18.4 and Oracle version is 12c
Thanks in advance
Discussion posts and replies are publicly visible
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
okay great, Few Java driver does not support few things when we connect to underlying databases.