Null pointer Exception -Execute Stored Procedure

Hi All,



I am trying to use "Execute Stored Procedure" smart service to invoke a stored procedure in the DB.

But when i try to execute the process it gives me following error alert.

"There is a problem with task “Execute Stored Procedure” in the process “TestProcessModel”. java.lang.NullPointerException"

Here are the values that i am passing to the smart service.



Data Source Name="jdbc/MSFT_RSU"

Procedure Name=="sp_ListBooks"

title_search="fun"

total_cost=0

resultSet1 (this is of type cdt to this and saving into the same for output from smart service)



But when we try to user alternate approach, specified



= with(

local!spResult: fn!executestoredprocedure( "jdbc/MSFT_RSU",

"sp_ListBooks",

{

{

name: "title_search",

value: "Fun"

}

}

...

OriginalPostID-253249