Error: Value exceeds limit of SMALLINT precision

Asked By darinmicky 210 points N/A Posted on - 07/19/2011

 

Hi,

During execution of my procedure, I have faced this error (Value exceeds limit of SMALLINT precision). I could not trace down the error to the exact location. Also the compiler does not tell me the line number or anything that helps me trace the error.

Can anyone help me locate the problem to solve this error? Thanks.

• Status: Open
• Question Views: 5710
• Answer Count: 1
• Vote Up 21 Vote Down

• Answer Accepted: No
• Question Category: Informix

Answered By y2caye 0 points N/A #84904

Error: Value exceeds limit of SMALLINT precision

 

The Exception is thrown when you attempt to insert a large number into SMALLINT column. The SMALLINT data type stores small whole numbers that range from –32,767 to 32,767. You might be trying to insert or update a field beyond those values that's why you are getting the error message.

You can try any of the following solutions:

1. Change the logic of your program to find where you're doing the insert or update and correct it.
2. Or if you really need to insert or update to a larger value, you can try to redefine the column or variable to use INTEGER or DECIMAL type.

About y2caye

Questions
7

Answers
4

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 08/02/2011
• Question Category: Informix