Skip to Main Content

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!

Strange ORA-01438: value larger than specified precision...error

C. BoutetMar 31 2008 — edited Mar 31 2008

When i issue a query like
SELECT * FROM shp_dtls WHERE shp_locn='AL';
i get the error

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

Why do i get an error like this for a SELECT query. Isn't this an INSERT related error?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 28 2008
Added on Mar 31 2008
2 comments
422 views