| Report Error: ORA 06502 Error [message #193468] |
Sun, 17 September 2006 11:03  |
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  |
 |
Littlefoot
Messages: 21813
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 |
shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan
|
Member |
|
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
