Skip to main content
Known Participant
Aug 5, 2021 6:37 AM UTC
Question

Stored Procedure Function not returning any data

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
)

    4 replies

    namratak0001
    Inspiring
    Aug 5, 2021 6:49 AM UTC

    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
    Aug 5, 2021 5:21 PM UTC

    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?

    Known Participant
    Aug 9, 2021 3:25 PM UTC

    Hi [mention:6b9f80ff18f9420082d13ef2d5121d56:e9ed411860ed4f2ba0265705b8793d05],

    Issue has been resolved, i have defined wrong column name.

    Regards,

    Ankita Singh

    danny.verb
    Employee
    Aug 5, 2021 5:39 PM UTC

    Also take a look at this community discussion regarding which functions are allowed by MariaDB