Home » Developer & Programmer » Forms » Customizing Error message in the password expire dialog
Customizing Error message in the password expire dialog [message #153270] Fri, 30 December 2005 13:26 Go to next message
vinodkumarn
Messages: 60
Registered: March 2005
Member
We are trying to apply security policy using Oracle profiles.

If a user's password has expired, the default Oracle form for changing the password pops up

If we try to enter the new password and if it passes the password_verify_function checks - all goes well.

However, if an invalid new password is entered, a message box "FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06502" appears. We are struggling to understand why the form is behaving like this.

what may be the reason and how to trap this error message with customized message

Thanks

Report message to a moderator

Re: Customizing Error message in the password expire dialog [message #153307 is a reply to message #153270] Sat, 31 December 2005 02:49 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
ORA-6502: Numeric or value error. Check your code in the ON-ERROR trigger. It probably has a variable that is too small.

MHE

Report message to a moderator

Re: Customizing Error message in the password expire dialog [message #154116 is a reply to message #153307] Thu, 05 January 2006 15:03 Go to previous message
vinodkumarn
Messages: 60
Registered: March 2005
Member
no all the variables have correct values.

can anyone help me reagarding this issue

Thanks
Vinod

Report message to a moderator

Previous Topic: Which trigger do I use?
Next Topic: chart item
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Feb 01 18:52:46 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.