Report Error: ORA 06502 Error [message #193468] |
Sun, 17 September 2006 11:03 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
di.l.rama@gmail.com
Messages: 2 Registered: September 2006
|
Junior Member |
|
|
Hi,
After entering the parameters, I hit the execute button, the Oracle Reports come back with the following error:
ORA - 06502: PL/SQL numberic or Value Error..
Pls help.
Thanks,
|
|
|
Re: Report Error: ORA 06502 Error [message #193506 is a reply to message #193468] |
Mon, 18 September 2006 00:13 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Oracle | 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.
|
|
|
|
|
Re: Report Error: ORA 06502 Error [message #193528 is a reply to message #193468] |
Mon, 18 September 2006 02:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
shahidmughal
Messages: 91 Registered: January 2006 Location: Faisalabad Pakistan
|
Member |
![shahid_mughal82%40yahoo.com](/forum/theme/orafaq/images/yahoo.png)
|
|
hi,
check all the formula columns in your report
the error accurs when you have set datatype different than
the value returned by formula
it also happens when inside datatype of the value returned is
different than variable defined.
same case with the Length of the fields.
if returned value is larger than the length defined in property palette then it happens.
again i will say you should check your formula columns carefully.
regards,
Muhammad Shahid Mughal
Database Application Developer
From Faisalabad Pakistan
|
|
|