Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00170: the SQL statement in an OPEN statement or FOR
loop must be a SELECT
- 1 Answers
- 3158 Views
- I also Faced
- E-Mail Answers
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 |
ORA-30550: index depends on a package/function spec/body which is not valid
QSM-00512: invalid summaries specified in the retention-list
ORA-38712: Corrupt flashback log record header: block string, offset string.
PCC-02387: Expecting an expression of type sql_cursor
ORA-36802: (XSTBLFUNC01) The OLAP_TABLE function must contain a DATAMAP that executes a FETCH command or a LIMITMAP.
ORA-24120: invalid string parameter passed to DBMS_REPAIR.string procedure
PCC-02011: found identifier greater than 128 characters (truncated)
IMG-00857: area list free failed
ORA-28235: algorithm not available
ORA-09291: sksachk: invalid device specified for archive destination
ORA-24364: internal error while padding blanks
PLS-01474: Use of ANY is non_ANSI
Oracle Errors 
