You’re offline. This is a read only version of the page.
I created a job that executes a SP, which then starts a SQL Agent Job. I made sure all of the permissions were correct, and I am receiving the below error. I used the Execute stored procedure (V2) action, the SQL connection does work as I can select the database and procedure name "sp_start_job". I then get the parameters list, where I tried to enter the job_name. When that didn't work I tried using the job_id instead, but I received the same error.
{
"status": 400,
"message": "Database functions with non-scalar parameters aren't supported.\r\n inner exception: Database functions with non-scalar parameters aren't supported.\r\nclientRequestId: 2a5c1de1-8884-4601-9420-c751d767d242",
"error": {
"message": "Database functions with non-scalar parameters aren't supported.\r\n inner exception: Database functions with non-scalar parameters aren't supported."
},
"source": "sql-ncus.azconn-ncus.p.azurewebsites.net"
}
I am also impacted by this
In my case I am calling a stored procedure usp-GetSomeThing with param @DataSource (nvarchar(128) which returns a resultset .
I have called a similar stored procedure without parameters and no issues.
Update: This might be a workaround for the main issue in this post https://powerusers.microsoft.com/t5/Building-Flows/Execute-Stored-procedure-Database-functions-with-non-scalar/td-p/1656231
Hi @adzh
Looks like this feature is not a supported feature in Flow.
There is reference related to logic apps for this.
LogicApps not supported this feature yet so there is a good chance this feature won't be available in flow.
Thanks.
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (
