PLS-00573: cannot constrain scale, precision, or range of an anchored type declaration

PLS-00573: cannot constrain scale, precision, or range of an anchored type declaration
Cause: A variable declared with %TYPE or %ROWTYPE cannot have a scale, precision, or range constraint. Example: x y%TYPE(10) is not acceptable. It is legal to add "NOT NULL" or non-conflicting CHARACTER SET constraints to anchored type declarations.
Action: Remove the constraint or use a type name instead of an anchored type.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00573：无法约束锚定类型声明的刻度，精度或范围,
.原因：用％TYPE或％ROWTYPE声明的变量不能具有比例，精度或范围约束。示例：xy％TYPE（10）是不可接受的。将“NOT NULL”或非冲突的CHARACTER SET约束添加到锚定类型声明是合法的。,
.操作：删除约束或使用类型名称而不是锚定类型。,
.

aiaiDBA

13718043309

010-86462881

PLS-00573: cannot constrain scale, precision, or range of an anchored type declaration

1 个回答

相似问题