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
seems like you already got everything working, but I'd like to add that the input params for oracle seem to require all caps format (ie `name: "IN_ID", value: 3270`)