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..

Answer / guest

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02251: subquery not allowed here

1 Answers  


RMAN-04006: error from auxiliary database: string

1 Answers  


ORA-24039: Queue string not created in queue table for multiple consumers

1 Answers  


TNS-00085: * reread - ask the process name to reread parameter files

1 Answers  


PLS-01505: ALTER is non-ANSI

1 Answers  






ORA-24407: connection pool already exists

1 Answers  


ORA-13041: failed to compare tile with element string.string.string

1 Answers  


ORA-16563: unable to add value, syntax error at "string"

1 Answers  


ORA-01557: rollback segment extents must be at least string blocks

1 Answers  


QSM-02154: MV is not fast refreshable even with view merging

1 Answers  


ORA-26053: Row was not loaded due to conversion error.

1 Answers  


ORA-27480: window "string" is currently open

1 Answers  


Categories