Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00642: local collection types not allowed in SQL statements
- 1 Answers
- 10605 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 |
RMAN-06433: error installing recovery catalog
RMAN-06475: parallelism setting out of range (1-254): number
ORA-19675: file string was modified during proxy copy
LPX-00231: invalid character ~1u ('~2c') found in a Name or Nmtoken
ORA-15035: no disks belong to diskgroup "string"
PLS-00336: non-object-table "string" illegal in this context
ORA-01252: cannot prevent writes - file string in recovery manager backup
ORA-12583: TNS:no reader
ORA-12510: TNS:database temporarily lacks resources to handle the request
ORA-09881: sstasfre/sstasdel: shmdt error, unable to detach tas read page
ORA-16119: building transaction at SCN string
QSM-01029: materialized view, string, is stale in ENFORCED integrity mode
Oracle Errors 
