PLS-00506: User Defined Constrained Subtypes are disallowed

PLS-00506: User Defined Constrained Subtypes are disallowed
Cause: An attempt was made to define a constrained subtype, but only unconstrained subtypes are allowed in this release of PL/SQL. For example, the following type definition is illegal: SUBTYPE Acronym IS VARCHAR2(5); -- illegal
Action: Remove the illegal type constraint.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00506：禁止用户定义的约束子类型,
.原因：尝试定义受限子类型，但在此版本的PL / SQL中仅允许无约束的子类型。例如，以下类型的定义是非法的：SUBTYPE首字母缩略词IS VARCHAR2（5）; - 非法,
.操作：删除非法类型约束。,
.

aiaiDBA

13718043309

010-86462881

PLS-00506: User Defined Constrained Subtypes are disallowed

1 个回答

相似问题