【Oracle点滴积累】解决ORA-20000: ORA-12899: value too large for column错误的方法

广告位招租！
知识无价，人有情，无偿分享知识，希望本条信息对你有用！

今天和大家分享ORA-20000: ORA-12899: value too large for column错误的解决方法，本文仅供参考，谢谢！

A fatal error occurred during processing of the com.********.servlet.pub.RegisterCustomer servlet:

ORA-20000: ORA-12899: value too large for column "XXX"."SITE"."STATE" (actual: 21, maximum: 20)Error in XXX.addNewRetailSite: unable to register site for customer number 945394

ORA-06512: at "XXX.ADDNEWRETAILSITE", line 110

ORA-06512: at line 1

Solution： 

alter table SITE modify (STATE varchar2(50));

最后，恭祝各位使用愉快！