SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-06502: PL/SQL: numeric or value error: number precision too large

659537Mar 10 2009 — edited Mar 10 2009

Hi,

The below code gives me error, but am not able to find the reason behind it. If i replace number(30,15) to simple number it solves.

Anybody could help me please.

declare
 a number(30,15);
begin
  a:= 4004834000000035;
end;

This post has been answered by Lukasz Mastalerz on Mar 10 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 7 2009

Added on Mar 10 2009

6 comments

693 views