PLS-00630: pipelined functions must have a supported collection return type

PLS-00630: pipelined functions must have a supported collection return type
Cause: A pipelined function was specified with an unsupported return type. The following are not supported as return types of pipelined functions:
- non-collections,

- PL/SQL tables,

- associative arrays,

- collections of PL/SQL types: rowid, mlslabel, long, long raw, boolean, binary_integer, pls_integer, string and urowid The following restrictions apply:

- If the return type is a collection of records, then each of the attributes of the record must be a supported type.

- A collection of records must not contain a record type as one of its attributes.

Action: Specify a supported collection type as the pipelined function return type.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00630：流水线功能必须具有支持的收集返回类型,
.原因：使用不支持的返回类型指定流水线函数。以下不支持作为流水线函数的返回类型：,
.- 非收藏，,
.,
.- PL / SQL表，,
.,
.- 关联数组，,
.,
.- PL / SQL类型的集合：rowid，mlslabel，long，long raw，boolean，binary_integer，pls_integer，string和urowid适用以下限制：,
.,
.- 如果返回类型是记录的集合，则记录的每个属性必须是支持的类型。,
.,
.- 记录集合不能包含记录类型作为其属性之一。,
.,
.操作：将受支持的集合类型指定为流水线函数返回类型。,
.

aiaiDBA

13718043309

010-86462881

PLS-00630: pipelined functions must have a supported collection return type

1 个回答

相似问题