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

Oracle Error Message

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

Reason for the Error

An OPEN cursor statement or cursor FOR loop can only invoke a SELECT statement, not an UPDATE, INSERT or DELETE.

Solution

Use only SELECT statements in OPEN or cursor FOR loops