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

Hi,

 

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

=with(
local!spResult: fn!executestoredprocedure(
"jdbc/OracleDataSource",
"SP_LISTBOOKS",
{
{name: "title_search", value: "%pig%"}
}
),
if(local!spResult.success,
local!spResult.result,
local!spResult.error
)
)

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?

Thanks

Rishu

  Discussion posts and replies are publicly visible