 frm-40735, ora-06502, forms 6i [message #131527] |
Mon, 08 August 2005 01:44  |
S_Intern
Messages: 3
Registered: August 2005
|
Junior Member |
|
|
Hi,
I'm trying to run a form on 6i, and I keep on getting this error:
FRM-40735 WHEN-MOUSE-ENTER trigger raised unhandled exception ORA-06502.
This occurs everytime my cursor passes over the 'next_block' item among the STD buttons.
Really appreciate some help.
S
|
|
|
|
| Re: frm-40735, ora-06502, forms 6i [message #131535 is a reply to message #131527] |
Mon, 08 August 2005 02:16  |
 |
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
|
Senior Member |
|
|
check this
ORA-06502 PL/SQL: numeric or value error
Cause: An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt is made to assign the value NULL to a variable declared NOT NULL, or if an attempt is made to assign an integer larger than 99 to a variable declared NUMBER(2).
Action: Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.
by
vamsi
|
|
|
|
|
|
|
|
| Re: frm-40735, ora-06502, forms 6i [message #131579 is a reply to message #131537] |
Mon, 08 August 2005 06:49 |
S_Intern
Messages: 3
Registered: August 2005
|
Junior Member |
|
|
sorry to bother you again,
I thought that was the end of it, but now the problem shifted to the save button... after I 'compile all' it works fine, but everytime I close and reopen the form, there's that error again but with the 'save' button.
thanks in advance
|
|
|
|
| Re: frm-40735, ora-06502, forms 6i [message #131655 is a reply to message #131579] |
Mon, 08 August 2005 18:54 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
I have a feeling that you have another form from which you are calling this problem form. I also expect that you have PLL and menu files. There is a FAQ on batch compiling and I believe you need to recompile and regenerate your whole application.
I expect the problem came about because your new form uses a few new members of your library and you deleted one of these routines when you didn't need it any more but you have not done a full recompile and generate of your higher level form.
Be careful if you have some people updating the PLL via its PLD and you have other people changing it via Form Builder as the latter will reorder the procedures and this causes the internal numbering to be changed and unless you do a compile all the new numbering system is not picked up.
Recompile your whole application and try it again.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
