Oracle Forms (MOSC)

MOSC Banner

Expired Account Error Not Being Returned in A Form

edited Sep 26, 2013 2:42AM in Oracle Forms (MOSC) 8 commentsAnswered ✓
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. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center