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

TNS-12232: TNS:No path available to destination

1 Answers  


TNS-04044: Specified gateways do not exist.

1 Answers  


ORA-06130: NETTCP: host access denied

1 Answers  


PLS-00538: subprogram or cursor 'string' is declared in an object type specification and must be defined in the object type body

1 Answers  


ORA-10582: The control file is not a backup control file

1 Answers  






RMAN-04026: unable to open a temporary file: "string"

1 Answers  


ORA-02151: invalid tablespace name: string

1 Answers  


TNS-02518: key negotiation error

1 Answers  


ORA-14049: invalid ALTER TABLE MODIFY PARTITION option

1 Answers  


ORA-12417: database object "string" not found

1 Answers  


ORA-29344: Owner validation failed - failed to match owner 'string'

1 Answers  


ORA-23327: imported deferred rpc data does not match string of importing db

1 Answers  


Categories