Hi
I have written a procedure for Mass User creation and user details update.
Everything works fine except for Password change.
Here is my code

:it_pwdate is the result set of the users for which password has to be changed.
I get the following error:
(range 3): transaction rolled back by an internal error: last n passwords can not be reused: number of old passwords which are not allowed to be reused is [5]
I have changed the password parameter to 0 and still i get same error. However if i execute the same SQL statement i am able to alter the password. It just doesn't work with the procedure.
Any help would be appreciated 😊
Thanks