Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-33443: (ESDREAD14) Discarding compiled code for workspace object because analytic workspace string is not attached.

1 Answers  


TNS-00206: Status Information for Interchange string:

1 Answers  


ORA-10644: SYSTEM tablespace cannot be default temporary tablespace

1 Answers  


ORA-08196: Flashback Table operation is not allowed on AQ tables

1 Answers  


ORA-12035: could not use materialized view log on "string"."string"

1 Answers  






ORA-01025: UPI parameter out of range

1 Answers   TCS,


SQL*Loader-00253: DB2 partition number has no significance -- ignored

1 Answers  


LSX-00300: group must have name or ref but not both

1 Answers  


ORA-15021: parameter "string" is not valid in string instance

1 Answers  


RMAN-06263: %-4s string string

1 Answers  


ORA-24031: invalid value, string should be non-NULL

1 Answers  


ORA-13421: null or invalid cell value

1 Answers  






Categories