Expired Account Error Not Being Returned in A Form
First, we are using Forms 11g, accessing a 11g database in DEV, QA and Production
In our login form we have code that catches when a user account is locked (dbms_error_code = -28000) or expired (dbms_error_code = -28001) and displays the appropriate message. The form works great in our DEV and QA environments, however it does not in the production environment. It always comes back saying it is a wrong username or password problem (dbms_error_code = -01017)
Interestingly in all three instances (DEV, QA and Production) it works when using a tool like PL/SQL Developer, TOAD, etc., For example, when a user account has expired and they try to log in, a dialog box pops up prompting them to reset their password.
In our login form we have code that catches when a user account is locked (dbms_error_code = -28000) or expired (dbms_error_code = -28001) and displays the appropriate message. The form works great in our DEV and QA environments, however it does not in the production environment. It always comes back saying it is a wrong username or password problem (dbms_error_code = -01017)
Interestingly in all three instances (DEV, QA and Production) it works when using a tool like PL/SQL Developer, TOAD, etc., For example, when a user account has expired and they try to log in, a dialog box pops up prompting them to reset their password.
0