PLS-00218: a variable declared NOT NULL must have an initialization assignment

PLS-00218: a variable declared NOT NULL must have an initialization assignment
Cause: In general, variables that have no initialization clause in their declaration are automatically initialized to NULL. This is illogical for NOT NULL variables; therefore, an initialization clause is required.
Action: Add an initialization clause to the variable declaration. If the initilization is too complicated for the syntax, one can add a function call (in a later release).

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00218：声明为NOT NULL的变量必须具有初始化分配,
.原因：通常，在其声明中没有初始化子句的变量将自动初始化为NULL。这对于NOT NULL变量是不合逻辑的; 因此，需要一个初始化子句。,
.Action：向变量声明添加一个初始化子句。如果启动对于语法来说太复杂，可以添加一个函数调用（在以后的版本中）。,
.

aiaiDBA

13718043309

010-86462881

PLS-00218: a variable declared NOT NULL must have an initialization assignment

1 个回答

相似问题