Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ERROR: value larger than specified precision allows for this column,

Status
Not open for further replies.
cm80

cm80

Technical User
May 3, 2001
85
0
0
US
Hi,
I have created a column with datatype NUMBER(3,8) but when I am inserting values I get an error saying:

"value larger than specified precision allows for this column"

The values I am inserting are not more than 3 figures to the left or 8 figures to the right of the decimal places so I don't know what the error is about.
PLEASE HELP!!!
 
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
Count records until a record value changes
Replies
2
Views
86
carp
carp
mmiah1982
  • Locked
  • Question
Extracting mutiple data items from DB with JSON string format column
Replies
2
Views
74
mmiah1982
mmiah1982
Tetol
  • Locked
  • Question
Update script is changing the number of records for the values updated each time I run the query
Replies
1
Views
63
carp
carp
szeiss
  • Locked
  • Question
Need to select the one value if it exists otherwise another value
Replies
4
Views
79
szeiss
szeiss
soushi01
  • Locked
  • Question
One column become multiple column display record 1
Replies
2
Views
48
soushi01
soushi01

Part and Inventory Search

Sponsor

Back
Top