Click HERE to see how Saviynt Intelligence is transforming the industry. |
07/19/2024 12:41 AM
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.
Solved! Go to Solution.
07/19/2024 01:21 AM - edited 07/19/2024 02:01 AM
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.