OraFAQ Forum: Forms » Message to indicate password expired

Home » Developer & Programmer » Forms » Message to indicate password expired (Forms 6i, Database 8i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Message to indicate password expired [message #390738]

Mon, 09 March 2009 09:02

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

cookiemonster
Messages: 13960
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?

Report message to a moderator

Re: Message to indicated password expired [message #390742 is a reply to message #390741]

Mon, 09 March 2009 09:44

Derek N
Messages: 80
Registered: September 2002

Member

It's an actual Oracle password.

Report message to a moderator

Re: Message to indicate password expired [message #390744 is a reply to message #390738]

Mon, 09 March 2009 10:07

cookiemonster
Messages: 13960
Registered: September 2008
Location: Rainy Manchester

Senior Member

What happens if you try to log in to sqlplus?

Report message to a moderator

Re: Message to indicate password expired [message #390825 is a reply to message #390738]

Mon, 09 March 2009 23:41

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

Report message to a moderator

Re: Message to indicate password expired [message #390908 is a reply to message #390738]

Tue, 10 March 2009 04:41

cookiemonster
Messages: 13960
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?

Report message to a moderator

Re: Message to indicate password expired [message #391090 is a reply to message #390908]

Tue, 10 March 2009 23:57

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.

Report message to a moderator

Previous Topic:	key mapping
Next Topic:	Non-database column in form populates wrong field

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 07 06:30:17 CST 2024