Home » Developer & Programmer » Forms » ORA-06502(Numeric Value Error) (Forms 10G)
ORA-06502(Numeric Value Error) [message #421315] Mon, 07 September 2009 07:47 Go to next message
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?

Re: ORA-06502(Numeric Value Error) [message #421317 is a reply to message #421315] Mon, 07 September 2009 07:52 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you also check that items and variables' size is correct?
Re: ORA-06502(Numeric Value Error) [message #421318 is a reply to message #421315] Mon, 07 September 2009 08:06 Go to previous messageGo to next message
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?
Re: ORA-06502(Numeric Value Error) [message #421973 is a reply to message #421315] Sat, 12 September 2009 10:56 Go to previous messageGo to next message
Kevin Meade
Messages: 2101
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
Re: ORA-06502(Numeric Value Error) [message #423049 is a reply to message #421973] Mon, 21 September 2009 23:11 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you tried running the Form in debug mode from the Forms Builder?

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


Current Time: Wed Dec 07 03:21:39 CST 2016

Total time taken to generate the page: 0.10400 seconds