PLS-00366: subtype of a NOT NULL type must also be NOT NULL

PLS-00366: subtype of a NOT NULL type must also be NOT NULL
Cause: After a subtype was defined as NOT NULL, it was used as the base type for another subtype defined as NULL. That is not allowed. For example, the code might look like DECLARE SUBTYPE Weekday IS INTEGER NOT NULL; SUBTYPE Weekend IS Weekday NULL; -- illegal instead of DECLARE SUBTYPE Weekday IS INTEGER NOT NULL; SUBTYPE Weekend IS Weekday;
Action: Revise the subtype definitions to eliminate the conflict.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00366：NOT NULL类型的子类型也必须不为空,
.原因：在将子类型定义为NOT NULL之后，它被用作另一个定义为NULL的子类型的基类型。这是不允许的。例如，代码可能看起来像DECLARE SUBTYPE Weekday IS INTEGER NOT NULL; SUBTYPE周末IS平日NULL; - 非法而不是DECLARE SUBTYPE工作日IS INTEGER NOT NULL; SUBTYPE周末IS平日,
.操作：修改子类型定义以消除冲突。,
.

aiaiDBA

13718043309

010-86462881

PLS-00366: subtype of a NOT NULL type must also be NOT NULL

1 个回答

相似问题