Hi slimdave,

You are correct i was missing By Values clause and i was also missing single quotes i was simply using old password value from variable that is why oracle was replacing password with old encrypted password value.

Thanks for your valuable input


Minesh