OraFAQ Forum: Forms » frm-40735, ora-06502, forms 6i

Home » Developer & Programmer » Forms » frm-40735, ora-06502, forms 6i

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

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

Report message to a moderator

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

Report message to a moderator

Re: frm-40735, ora-06502, forms 6i [message #131537 is a reply to message #131535]

Mon, 08 August 2005 02:38

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Check the logic you have in your when-mouse-move and when-mouse-enter tirrgers, you may be adding '1' to a character field.

Alternatively, try doing a compile all (Ctrl-Shft-k) then a generate (Ctrl-t) and see if that fixes it.

David

Report message to a moderator

Re: frm-40735, ora-06502, forms 6i [message #131558 is a reply to message #131537]

Mon, 08 August 2005 04:55

S_Intern
Messages: 3
Registered: August 2005

Junior Member

djmartin you're awesome!

Thanks to both of you!

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

Previous Topic:	HELP: MAKE A DEFAULT VALUE FOR LIST ITEM
Next Topic:	Q about related record group?pls quickly .........

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 06 04:07:14 CDT 2025