OraFAQ Forum: Forms » ORA-06502(Numeric Value Error)

Home » Developer & Programmer » Forms » ORA-06502(Numeric Value Error) (Forms 10G)

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

ORA-06502(Numeric Value Error) [message #421315]

Mon, 07 September 2009 07:47

gurupatham
Messages: 66
Registered: March 2008
Location: Chennai

Member

Hi,

I have added some piece of code in the existing form.i am getting ORA-06502 error While i execute the form . I know this is because of data type mismatch or numeric value error. So I have checked all the places where ever is possible. I ensured there is no data type mismatch or numeric issue. But i am wondered when i give this statement " message('test');pause; " (for debugging purpose), the above error is not getting displayed . It is working fine. Can anyone help me what would be the root cause for this issue?

Report message to a moderator

Re: ORA-06502(Numeric Value Error) [message #421317 is a reply to message #421315]

Mon, 07 September 2009 07:52

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you also check that items and variables' size is correct?

Report message to a moderator

Re: ORA-06502(Numeric Value Error) [message #421318 is a reply to message #421315]

Mon, 07 September 2009 08:06

gurupatham
Messages: 66
Registered: March 2008
Location: Chennai

Member

Hi,

yes I have checked items and variable.In case if there is any numeric value error , this error should be displayed consistently.But in our case it is not displaying the error message consistently. it is suppressed by giving "MESSAGE" statement. is any other reason to cause such kind of issue?

Report message to a moderator

Re: ORA-06502(Numeric Value Error) [message #421973 is a reply to message #421315]

Sat, 12 September 2009 10:56

Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA

Senior Member

you need to isolate the piece of code causing the error then fix it.

This will take some time, but one approach is to comment out code until the error goes away, then uncomment back on code until the error comes back. Repeat as needed, eliminating code parts till you find the line that is causing the error.

There is no substitute for basic debugging. It takes time, but is most of what program development is about.

Good luck, Kevin

Report message to a moderator

Re: ORA-06502(Numeric Value Error) [message #423049 is a reply to message #421973]

Mon, 21 September 2009 23:11

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

Senior Member
Account Moderator

Have you tried running the Form in debug mode from the Forms Builder?

David

Report message to a moderator

Previous Topic:	line is down problem
Next Topic:	Query-only mode form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 07:25:16 CDT 2024