Invoking a Stored Procedure in DB

[Pavan1603]

I am using a stored procedure called Updateuserdetails to update few values to my DB by using below 

UPDATEUSERJSON:

{
"UpdateUserQry": "CALL Updateuserdetails('${user.customproperty10}', '${user.email}', '${user.companyname}', '${user.employeeid}')"
}

But while provisioning the update task it is throwing incorrect syntax near '${user.customproperty10}' using its value like below, please check and assist me with correcting it.

[Pavan1603 · Accepted solution]

Issue resolved as I have modified my UPDATEUSERJSON as below.

UPDATEUSERJSON:

{
"UpdateUserQry": "EXEC Updateuserdetails '${user.customproperty10}', '${user.email}', '${user.companyname}', '${user.employeeid}' "
}

Instead of using CALL I have used usual SQL command EXEC.