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-31045: Cannot store more than string extras outside the root XML node

1 Answers  


DGM-16999: Instance "string" was not found.

1 Answers  


QSM-01031: materialized view, string, is stale in TRUSTED integrity mode

1 Answers  


ORA-16509: the request timed out

1 Answers  


ORA-02761: File number to be canceled is negative.

1 Answers  


give full details of this ORA-12988: cannot drop column from table owned by SYS

8 Answers   Oracle,


ORA-38411: invalid datatype for the column storing expressions

1 Answers  


RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows

1 Answers  


NID-00111: Oracle error reported from target database while executing string string

1 Answers  


NNL-00344: Save_config_on_stop is currently ON

1 Answers  


NNO-00308: server will restart in number seconds

1 Answers  


ORA-24180: invalid transformation expression, the transformation expression does not evaluate to the target type/attribute

1 Answers  


Categories