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

No comments:

Post a Comment