FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06502
533281Feb 5 2009 — edited Feb 6 2009Hi,
We are facing a strange problem.
Our application is having a form for the user to change the password. The users are database users having access to the schema in which our tables are placed. Some of the users are getting the error FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06502 when they try to change the password. It is found that the user name of these users have more than 8 characters length. Other users with username with 8 or less character length is able to change the password.
The form is using a procedure to change the password. The variables handing the username and password are varchar2(80)
Thanks in advance for responses.
Sreesha