Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00642: local collection types not allowed in SQL statements
- 1 Answers
- 10460 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-40004: penalty must be negative for BLAST-N
ORA-22303: type "string"."string" not found
ORA-12518: TNS:listener could not hand off client connection
ORA-02757: osnfop: fork_and_bind failed
IMG-00810: boundary queue initialization failed
ORA-07456: cannot set RESOURCE_MANAGER_PLAN when database is closed
ORA-02264: name already used by an existing constraint
ORA-29351: can not transport system, sysaux, or temporary tablespace 'string'
PROT-00012: Oracle Cluster Registry to be upgraded has an unsupported version
ORA-02805: Unable to set handler for SIGTPA
NID-00321: Proceeding with operation
ORA-01351: tablespace given for Logminer dictionary does not exist
Oracle Errors 
