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

Question Posted / guest

1 Answers
3149 Views
I also Faced
E-Mail Answers

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-31466: no publications found

1 Answers

ORA-38731: Expected version string does not match string in log header.

1 Answers

ORA-01943: IDENTIFIED BY already specified

1 Answers

ORA-12025: materialized view log on "string"."string" already has primary keys

1 Answers

ORA-24162: name value pair list is full, cannot add another entry

1 Answers

ORA-14031: partitioning column may not be of type LONG or LONG RAW

1 Answers

ORA-00112: value of string is null

1 Answers

DRG-11849: Heuristic Expiration

1 Answers

ORA-33308: (DBVALID04) SEVERE ERROR: Record number used but not allocated

1 Answers

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

0 Answers

ORA-29900: operator binding does not exist

1 Answers

ORA-13115: [string]_EDGE$ table does not exist

1 Answers

For more Oracle Errors Interview Questions Click Here