Execute Stored Procedure (V2) parameter error

[adzh]

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"

}

[abm · Accepted solution]

Hi  @adzh 

Looks like this feature is not a supported feature in Flow. 

There is reference related to logic apps for this. 

https://social.msdn.microsoft.com/Forums/vstudio/en-US/942a1dcb-376b-4c6f-bc37-e89ca250b70f/azure-lo...

LogicApps not supported this feature yet so there is a good chance this feature won't be available in flow.

Thanks.

[adzh]

abm,

Thank you for the reply. Hopefully this is something they add down the line.

Thanks