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)
Discussion posts and replies are publicly visible
Hi ankitas209
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",{}))
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?
Also take a look at this community discussion regarding which functions are allowed by MariaDB
Hi Peter Lewis,
Issue has been resolved, i have defined wrong column name.
Regards,
Ankita Singh