ORA-22908: reference to NULL table value

ORA-22908: reference to NULL table value
Cause: The evaluation of the THE subquery or nested table column resulted in a NULL value implying a NULL table instance. The THE subquery or nested table column must identify a single non-NULL table instance.
Action: Ensure that the evaluation of the THE subquery or nested table column results in a single non-null table instance. If happening in the context of an insert statement where the THE subquery is the target of an insert, then ensure that an empty nested table instance is created by updating the nested table column of the parent table's row specifying an empty nested table constructor.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:45

ORA-22908：引用NULL表值,
.原因：对子查询或嵌套表列的求值导致NULL值，表示NULL表实例。THE子查询或嵌套表列必须标识单个非NULL表实例。,
.操作：确保对子查询或嵌套表列的求值导致单个非空表实例。如果发生在插入语句的上下文中，其中THE子查询是插入的目标，则通过更新父表的行的嵌套表列（指定空的嵌套表构造函数）来确保创建空的嵌套表实例。,
.

aiaiDBA

13718043309

010-86462881

ORA-22908: reference to NULL table value

1 个回答

相似问题