Skip to Content
0
Former Member
Jul 26, 2016 at 06:47 AM

Unable to Alter user using Procedure

716 Views

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

Attachments