Skip to Main Content
Forums

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-01438: value larger than specified precision allows for this column'

Thirupathi ReddyFeb 18 2011 — edited Feb 18 2011
While inserting different Cheaper Products entries into this table PF_PRODUCT_VIEWS_PROFILE,i am having this issue of 'java.sql.SQLException: ORA-01438: value larger than specified precision allows for this column' .


As i see in the tables (desc pf4.PF_PRODUCT_VIEWS_PROFILE; & desc PFCA4.DCS_PRICE_LEVEL;), i see the precision for price in the table PF_PRODUCT_VIEWS_PROFILE as NUMBER(12,7) & the precision for price in the table DCS_PRICE_LEVEL as NUMBER(19,7).So there is a difference of 7 units precision for price in the table PF_PRODUCT_VIEWS_PROFILE which is causing this issue.So this would be the fix.


Could you please validate my observations,So that i can change the precision for price in the table PF_PRODUCT_VIEWS_PROFILE.
Need to confirm other columns in the table PF_PRODUCT_VIEWS_PROFILE doesn't exceed their precision values before we make this change.
This post has been answered by 789895 on Feb 18 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2011
Added on Feb 18 2011
5 comments
1,074 views