Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00642: local collection types not allowed in SQL statements
- 1 Answers
- 10494 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: A locally-defined (i.e. not schema level) collection
type was used in a SQL statement. The type must be defined
in a schema to be accepted in a SQL statement.
Action: Define the collection type in your schema, not
inside a PL/SQL subprogram.
Please add more information about this Error
| Is This Answer Correct ? | 2 Yes | 1 No |
SQL*Loader-00654: Variable length field exceeds maximum length.
QSM-02005: named view in FROM list
ORA-39957: invalid warning category
ORA-12811: PARALLEL_MIN_SERVERS must be less than or equal to PARALLEL_MAX_SERVERS, string
ORA-13908: Invalid combination of metrics id and object type parameters.
ORA-32743: command cannot be executed on remote instance
DRG-12601: invalid user datastore procedure name: string
ORA-30731: scope constraint not allowed on nested table column when the nested table is being created
DRG-11614: URL store: communication with host specified in string timed out
ORA-16213: ddl encountered, stopping apply engine
ORA-24058: cannot downgrade QUEUE_TABLE that has propagation in a prepared state
TNS-00298: Request to Navigator: string
Oracle Errors 
