Stored Procedure Error ORA-06550: line 1, column 7: PL/SQL: Statement ignored



I have been trying to use execute stored procedure smart service but when I followed the same use case mentioned in Documentation for Stored Procedure with SP_BOOKLIST, while using the smart Service in Process I got the error:

ORA-06550: line 1, column 7:PLS-00306: wrong number or types of arguments in call to 'SP_LISTBOOKS'ORA-06550: line 1, column 7:PL/SQL: Statement ignored


When I am following the same in function as per documentation, I am getting the error:

Interface Definition: Expression evaluation error : Invalid index: Cannot index property '_foundation' of type Text into type List of Variant:

Attached is the code, I used in interface Rule

local!spResult: fn!executestoredprocedure(
{name: "title_search", value: "%pig%"}

I also checked permission in Oracle DB & the connection type is "Basic" & role is "Default".

Can anyone please guide where I am getting it wrong & how can I fix it?



  Discussion posts and replies are publicly visible