Oracle DB update account json

[sk]

Hello experts,

We are trying to add the case statement in update account json and

• Added a dynamic attribute in the request form that is mapped to cp3 to indicate the status of the account on the “Modify Account” form. This will be hidden on creation and would be visible only on an update operation.

Existing updateaccount query

{"UpdateAccountQry": "ALTER USER \"${user.username}\" ACCOUNT (case when '${AccountStatus}'='Active' then 'UNLOCK' when '${AccountStatus}'='Inactive' then 'LOCK' end)"
}

getting the error SAV - Error while updating account - ORA-00921: unexpected end of SQL command

[rushikeshvartak]

{
"UpdateAccountQry": "ALTER USER \"${user.username}\" ACCOUNT CASE WHEN '${AccountStatus}' = 'Active' THEN 'UNLOCK' WHEN '${AccountStatus}' = 'Inactive' THEN 'LOCK' END"
}