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
3081 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-01592: error converting Version 7 rollback segment (string) to Oracle 8 format

1 Answers

IMG-00846: adjacency matrix allocation failed

1 Answers

ORA-13052: unsupported geometric type for geometry string.string

1 Answers

ORA-26520: internal memory failure

1 Answers

ORA-07271: spwat: invalid oracle process number.

1 Answers

PCC-00133: Command line option MODE=ANSI required with option NLS_LOCAL=YES

1 Answers

ORA-27476: "string.string" does not exist

1 Answers

ORA-02441: Cannot drop nonexistent primary key

1 Answers

ORA-33012: (XSAGDNGL05) AGGMAP workspace object contains invalid syntax.

1 Answers

RMAN-08514: archive log filename=string recid=string stamp=string

1 Answers

RMAN-06443: error upgrading recovery catalog

1 Answers

ORA-29905: method string does not exist in type string.string

1 Answers

For more Oracle Errors Interview Questions Click Here