aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

PLS-00729: only widening of the collection element type is allowed

PLS-00729: only widening of the collection element type is allowed
Cause: Modification to the collection element type did not widen its constraints or attempted to change the type of the element. For NUMBER types, scale and precision can be changed to allow increase in number of digits after and before the decimal point. For VARCHAR2 and RAW type attributes the size can be increased.
Action: Change the constraint specification so as to widen the existing constraints.

请先 登录 后评论

1 个回答

小智
PLS-00729:只允许扩展采集元素类型,
.原因:对集合元素类型的修改没有扩大其约束或尝试更改元素的类型。对于NUMBER类型,可以改变比例和精度,以允许增加小数点后的位数。对于VARCHAR2和RAW类型属性,可以增加大小。,
.操作:更改约束规范以扩大现有约束。,
.
请先 登录 后评论