Home » Developer & Programmer » Reports & Discoverer » Report Error: ORA 06502 Error
Report Error: ORA 06502 Error [message #193468] Sun, 17 September 2006 11:03 Go to next message
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 messageGo to next message
Littlefoot
Messages: 20897
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 #193526 is a reply to message #193468] Mon, 18 September 2006 02:11 Go to previous messageGo to next message
sandeepk7
Messages: 137
Registered: September 2006
Senior Member

Check the formulla in which this error is occuring.

ORA - 06502: PL/SQL numberic or Value Error..

Might be a number defined variable is getting an non numeric value.

Sandy
Re: Report Error: ORA 06502 Error [message #193528 is a reply to message #193468] Mon, 18 September 2006 02:28 Go to previous message
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
Previous Topic: Unable print in taxt format
Next Topic: Random Problem in Report 6i Run time
Goto Forum:
  


Current Time: Wed Dec 07 06:41:41 CST 2016

Total time taken to generate the page: 0.07967 seconds