Home » Developer & Programmer » Forms » Message to indicate password expired (Forms 6i, Database 8i)
Message to indicate password expired [message #390738] Mon, 09 March 2009 09:02 Go to next message
Derek N
Messages: 80
Registered: September 2002
Member
How do I go about indicating to the user that their password has already expired/locked when they attempt to log onto the application.

Currently if their password has expired/locked there are no messages displayed indicating same.

Thanks

[Updated on: Mon, 09 March 2009 09:40]

Report message to a moderator

Re: Message to indicated password expired [message #390741 is a reply to message #390738] Mon, 09 March 2009 09:39 Go to previous messageGo to next message
cookiemonster
Messages: 12406
Registered: September 2008
Location: Rainy Manchester
Senior Member
Is this password an actual oracle password (you can use it in sqlplus), or an application password that you've got stashed in a table somewhere?
Re: Message to indicated password expired [message #390742 is a reply to message #390741] Mon, 09 March 2009 09:44 Go to previous messageGo to next message
Derek N
Messages: 80
Registered: September 2002
Member
It's an actual Oracle password.
Re: Message to indicate password expired [message #390744 is a reply to message #390738] Mon, 09 March 2009 10:07 Go to previous messageGo to next message
cookiemonster
Messages: 12406
Registered: September 2008
Location: Rainy Manchester
Senior Member
What happens if you try to log in to sqlplus?
Re: Message to indicate password expired [message #390825 is a reply to message #390738] Mon, 09 March 2009 23:41 Go to previous messageGo to next message
Derek N
Messages: 80
Registered: September 2002
Member
When I attempt to log in to sql*plus I get the following error:

SQL> conn abc@test
Enter password: *****
ERROR:
ORA-28000: the account is locked
Re: Message to indicate password expired [message #390908 is a reply to message #390738] Tue, 10 March 2009 04:41 Go to previous messageGo to next message
cookiemonster
Messages: 12406
Registered: September 2008
Location: Rainy Manchester
Senior Member
Well as far as I'm aware oracle forms should report that error message.
So presumably there is some code in your form that's swallowing the error.
Do you have any on-error triggers / exception handlers?
Re: Message to indicate password expired [message #391090 is a reply to message #390908] Tue, 10 March 2009 23:57 Go to previous message
Derek N
Messages: 80
Registered: September 2002
Member
There is an ON-ERROR trigger in the form and it does not trap the ORA-28000 error. I have now included code to check the ERROR_CODE and if it is 28000 to display a message and log off the form.

Thanks for your help.
Previous Topic: key mapping
Next Topic: Non-database column in form populates wrong field
Goto Forum:
  


Current Time: Tue Dec 06 04:41:09 CST 2016

Total time taken to generate the page: 0.06502 seconds