PLS-00507: a PLSQL Table may not contain a table or a record with composite fields

PLS-00507: a PLSQL Table may not contain a table or a record with composite fields
Cause: In a TABLE type definition, a nested record type was specified as the element type. This is not allowed. All fields in the record must be scalars.
Action: Remove the TABLE type definition, or replace the nested record type with a simple record type.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00507：PLSQL表可能不包含具有复合字段的表或记录,
.原因：在TABLE类型定义中，嵌套的记录类型被指定为元素类型。这是不允许的。记录中的所有字段必须是标量。,
.操作：删除TABLE类型定义，或者使用简单的记录类型替换嵌套的记录类型。,
.

aiaiDBA

13718043309

010-86462881

PLS-00507: a PLSQL Table may not contain a table or a record with composite fields

1 个回答

相似问题