Question

Stored Procedure Function not returning any data

Forum|Forum|4 years ago
August 5, 2021
4 replies
0 views

Hello,

I am using executestoredprocedure() function to get the data, but when i am executing the expression rule it is not returning any data.

a!localVariables(
local!result: executestoredprocedure(
dataSourceName: cons!dataSource,
procedureName: cons!storedProc,
inputs:{
name:"user_id",
value:"ankita12"
}
), local!result
)

namratak0001

Hi [mention:37640185bf1045bf9719535ecf850e86:e9ed411860ed4f2ba0265705b8793d05]

Please try below code:

a!localVariables(
local!result: executestoredprocedure(
dataSourceName: cons!dataSource,
procedureName: cons!storedProc,
inputs:{
{
name:"user_id",
value:"ankita12"
}
}
),
index(local!result,"result",{})
)

peter.lewis

Employee

Can you provide more information? What troubleshooting steps did you try? is the stored procedure executing but just not returning the results or is it not even executing? What happens if you run this as a smart service in a process modle?