PLS-00429: unsupported feature with RETURNING clause

PLS-00429: unsupported feature with RETURNING clause
Cause:
- INTO clause and RETURNING clause cannot be use in the same statement

- RETURNING clause is currently not supported for object type columns, LONG columns, records, %rowtypes, remote tables and INSERT with subquery. This is as ORA-28815.

Action: Use separate select statement to get the values.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00429：RETURNING子句不支持的功能,
.原因：,
.- INTO子句和RETURNING子句不能在同一个语句中使用,
.,
.- 对象类型列，LONG列，记录，％rowtypes，远程表和具有子查询的INSERT目前不支持RETURNING子句。这是ORA-28815。,
.,
.操作：使用单独的select语句来获取值。,
.

aiaiDBA

13718043309

010-86462881

PLS-00429: unsupported feature with RETURNING clause

1 个回答

相似问题