ORA-01438 错误
任何人都可以帮助我解决这个例外吗?
ORA-01438: 值大于此列允许的指定精度
ORA-06512:位于“DM001.DFEE_AFT_IUD_JOURNAL”,第 58 行
ORA-04088:执行触发器“DM001.DFEE_AFT_IUD_JOURNAL”期间出错 ORA-06512:第 4 行
Can anyone help me with this exception?
ORA-01438: value larger than specified precision allowed for this column
ORA-06512: at "DM001.DFEE_AFT_IUD_JOURNAL", line 58
ORA-04088: error during execution of trigger 'DM001.DFEE_AFT_IUD_JOURNAL' ORA-06512: at line 4
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
您尝试将一个值存储到记录的字段中,该值比表的列定义允许的长度长。
您的列可能被定义为 NUMBER(3),但您尝试在其中存储更长的数字(例如 1250)。
You are trying to store a value into the field of a record that is longer than the column definition of the table allows.
Your column might be defined as NUMBER(3), but you're trying to store a longer number like 1250 into it.
您试图在“精度”大于定义的任何列中插入一个值。
You are trying to insert a value in any column that has a "precision" larger than the defined.
您可能尝试输入一个大于创建表时定义的值(即 varchar2(4) -> 尝试的值 10000)
You've probably tried to enter a value greater than de defined when you created the table (i.e. varchar2(4) -> value tried 10000)