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-36875: (XSFTDSC05) LIMITMAP is missing or is not a string literal.

1 Answers  


ORA-08448: syntax error in DECIMAL-POINT environment clause

1 Answers  


ORA-29881: failed to validate indextype

1 Answers  


ORA-14049: invalid ALTER TABLE MODIFY PARTITION option

1 Answers  


ORA-09955: scgcan: unexpected return status when canceling a lock

1 Answers  


ORA-30750: cannot enable column string to store objects of type string.string

1 Answers  


ORA-06903: CMX: cannot read transport address of remote application

1 Answers  


ORA-00965: column aliases not allowed for '*'

1 Answers  


ORA-31450: invalid value for change_table_name

1 Answers  


ORA-07243: supplied buffer not big enough to hold entire line

1 Answers  


ORA-02266: unique/primary keys in table referenced by enabled foreign keys

1 Answers  


ORA-07635: smsdbp: $SETPRT failure

1 Answers  


Categories