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
Messages: 31
Registered: April 2006
Location: Chennai

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.

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
Messages: 4621
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
Messages: 11
Registered: October 2006
Junior Member
ORA-06502 PL/SQL: numeric or value error string
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).

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: Tue Oct 25 21:44:00 CDT 2016

Total time taken to generate the page: 0.14284 seconds