PLS-00170: the SQL statement in an OPEN statement or FOR loop must be a SELECT

PLS-00170: the SQL statement in an OPEN statement or FOR loop must be a SELECT
Cause: An OPEN cursor statement or cursor FOR loop can only invoke a SELECT statement, not an UPDATE, INSERT or DELETE.
Action: Use only SELECT statements in OPEN or cursor FOR loops

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:01

PLS-00170：OPEN语句或FOR循环中的SQL语句必须是SELECT,
.原因： OPEN游标语句或游标FOR循环只能调用SELECT语句，而不是UPDATE，INSERT或DELETE。,
.操作：仅在OPEN或游标FOR循环中使用SELECT语句,
.

aiaiDBA

13718043309

010-86462881

PLS-00170: the SQL statement in an OPEN statement or FOR loop must be a SELECT

1 个回答

相似问题