Home » SQL & PL/SQL » SQL & PL/SQL » ORA 06502 error
ORA 06502 error [message #168215] Wed, 19 April 2006 05:41 Go to next message
anandhi
Messages: 31
Registered: April 2006
Location: Chennai
Member
Hi

I am receiving an error ORA 06502 PL/SQL: numeric or value. There is no data in the table. Eventhough i am receiving this error.

Please help me.

Thanks
A
Re: ORA 06502 error [message #168250 is a reply to message #168215] Wed, 19 April 2006 08:15 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
WHEN are you receiving it? C'mon, help us out a little. Jeez.
Re: ORA 06502 error [message #206391 is a reply to message #168215] Wed, 29 November 2006 19:18 Go to previous message
artmast
Messages: 11
Registered: October 2006
Junior Member
ORA-06502 PL/SQL: numeric or value error string
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.

From http://oratip.com/ORA-06502.html
Previous Topic: xmlconcat slow
Next Topic: update not happeing
Goto Forum:
  


Current Time: Sat Dec 10 11:10:23 CST 2016

Total time taken to generate the page: 0.04782 seconds