OraFAQ Forum: SQL & PL/SQL » Numeric Or Value Error

Home » SQL & PL/SQL » SQL & PL/SQL » Numeric Or Value Error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Numeric Or Value Error [message #37367]

Sat, 02 February 2002 06:51

Pavan Kumar
Messages: 10
Registered: October 2000

Junior Member

Hi,
I have a strange problem. I am trying to load data into a table through a PL/SQL procedure. I get an error which says that Numeric Or Value Error - ORA06502- Precision Exceeds limit. But the values for the columns which have Number with precision are all zeroes. Can some one help me out ?

Thanks
Pavan

Report message to a moderator

Re: Numeric Or Value Error [message #37368 is a reply to message #37367]

Sat, 02 February 2002 07:22

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

what is declared number variable or column length?
or

did you specify length or just declared as number?

Report message to a moderator

Re: Numeric Or Value Error [message #37370 is a reply to message #37368]

Sun, 03 February 2002 18:42

Pavan Kumar
Messages: 10
Registered: October 2000

Junior Member

Hi,
Thanks for the response. It is a number variable and the column length is 8,2. I did mention the length in the code. So any further thoughts ?

Thanks
Pavan

Report message to a moderator