password verify function codes
580896Jun 28 2007 — edited Jun 30 2007Hi,
The password complexity verification routine performs the following checks:
1 The password has a minimum length of four.
2 The password is not the same as the username.
3 the password is too simple, This is not allowed
....etc.
For these validations i run password_verify function and assign this to profile moreover, I assign profile to <my user>.
For 1: Whenever I changed the password(violation of above rules) from SQLPLUS, gives me error.
ORA-28003: password verification for the specified password failed
ORA-20002: Password length is less than 8. Should be 8 or longer
For 2: ORA-28003: password verification for the specified password failed
ORA-20001: Password same as or similar to username
For 3: I get in sqlplus
ORA-28003: password verification for the specified password failed
ORA-20002: Password too simple. This is not allowed
Now i need to trap these in the form, which error code i need to check in the form? i would appreciate your help please.
IF DBMS_ERROR_CODE = <> THEN ..