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
Could you please post about your stored procedure in terms of what inputs and out parameters?
Hi, Here is the snippet from stored procedure:
create or replace PROCEDURE getdata ( in_id IN NUMBER, sp_results IN OUT SYS_REFCURSOR) AS
Body
open sp_results for v_query_string;
END;
Do you have any suggestions on this? I have same kind of scenario to call from Appian - I am getting an error, is it possible to return the record?? (using refcursor) to Appian.
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
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.
okay great, Few Java driver does not support few things when we connect to underlying databases.
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`)