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
- 3143 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-39146: schema "string" does not exist
ORA-25959: join index must be of the bitmap type
QSM-01072: materialized view, string, and query have different joins between tables, string
RMAN-08010: channel string: specifying datafile(s) in backupset
ORA-02030: can only select from fixed tables/views
PLS-00146: duplicate external TRUSTED/UNTRUSTED specification in subprogram expression
ORA-01591: lock held by in-doubt distributed transaction string
ORA-36740: A CHILDLOCK was detected in your valueset
ORA-06539: target of OPEN must be a query
ORA-09799: File label retrieval failed.
ORA-23345: table "string"."string" not registered to collect statistics
ORA-22901: cannot compare nested table or VARRAY or LOB attributes of an object type
Oracle Errors 
