Re: ORA-01438: value larger than specified precision allows

[Jerry Coleman <colemanj@WASHPOST.COM>]

ORA-01438 value larger than specified precision allows for this column
      Cause: When inserting or updating records, a numeric value was
      entered that exceeded the precision defined for the column.
      Action: Enter a value that complies with the numeric column's
      precision, or use the MODIFY option with the ALTER TABLE command to
      expand the precision.

Sounds like you're inserting a value with too many decimal places into a
column with a specified precision (allowed decimal points).  In short, I
would identify the column, and perhaps use the SQR or Oracle round
function.





                      "Brickl, Maria"
                      <mbrickl@UWC.EDU>        To:       SQR-USERS@list.iex.net
                      Sent by:                 cc:
                      "Discussion of           Subject:  ORA-01438: value 
larger than specified precision allows
                      SQR, Brio
                      Software's
                      database
                      reporting
                      language"
                      <SQR-USERS@list.i
                      ex.net>


                      05/15/02 11:54 AM
                      Please respond to
                      sqr-users






Does anyone know what the below error means?

ORA-01438: value larger than specified precision allows for this column.

I am not sure where I should look to find this error. Any suggestions?

*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
Maria K Brickl
mbrickl@uwc.edu <mailto:mbrickl@uwc.edu>
Information Systems Programmer/Analyst
University of Wisconsin Colleges
780 Regent St, PO Box 8680, Madison, WI  53708-8680
Phone: 608.265.2677 / Fax: 608.265.5770
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*