Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00642: local collection types not allowed in SQL statements
- 1 Answers
- 10365 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 |
ORA-28576: lost RPC connection to external procedure agent
ORA-16788: Unable to set one or more database configuration property values
LSX-00284: duplicate constraint name "~S"
SQL*Loader-00423: element count is greater than maximum allowed for the column
RMAN-08059: media recovery failed
NZE-29240: the cryptographic engine does not recognize the algorithm
ORA-12084: must use ALTER MATERIALIZED VIEW to alter "string"."string"
ORA-25425: connection lost during rollback
ORA-08266: create_ora_addr: cannot register name in nameserver
NZE-29028: Server verification failure when using SSL 2.0
QSM-01107: Partition Containment Tracking (PCT) rewrite is not allowed
ORA-19909: datafile string belongs to an orphan incarnation
Oracle Errors 
