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-24366: migratable user handle is set in service handle

1 Answers  


NNL-00291: Statistic counters are next reset in string

1 Answers  


ORA-02092: out of transaction table slots for distributed transaction

1 Answers  


ORA-16604: unable to describe template using package "string"

1 Answers  


ORA-01221: data file string is not the same file to a background process

1 Answers  






ORA-02277: invalid sequence name

1 Answers  


ORA-18004: outline already exists

1 Answers  


NNL-00832: Deletes refused, name is a topology name: number

1 Answers  


IMG-00814: fail queue free failed

1 Answers  


SQL*Loader-00533: OCI return status: unknown, value is number

1 Answers  


ORA-22869: depth of type dependency hierarchy exceeds maximum limit

1 Answers  


DRG-11528: LONG or LONG RAW column defintion found in structure data

1 Answers  


Categories