PCC-02360: This array type is invalid for use with ARRAYLEN
statement



PCC-02360: This array type is invalid for use with ARRAYLEN statement..

Answer / guest

Cause: Arrays of some host variables types are not allowed
and hence also cannot be used in ARRAYLEN statements.
VARCHAR and DATE are examples.

Action: Specify an array with a datatype that can be used in
host arrays.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-30383: specified dimension level does not exist in the attribute

1 Answers  


RMAN-12000: execution layer initialization failed

1 Answers  


ORA-07257: spdcr: translation error expanding program name.

2 Answers  


ORA-39001: invalid argument value

1 Answers  


ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE

1 Answers  


ORA-36712: (XSMXALLOC02) Relation workspace object must be a one-dimensional self-relation to be used as a SOURCE or BASIS with ALLOCATE.

1 Answers  


TNS-12674: Shared server: proxy context not saved

1 Answers  


ORA-29369: invalid method name string specified for consumer group string

1 Answers  


SQL*Loader-00425: column string makes illegal reference to collection field string

1 Answers  


ORA-36155: (XSMXAGGRFROM) workspace object must be a variable or formula of a similar data type to workspace object to be used with FROM, or a TEXT variable or formula to be used with FROMVAR.

1 Answers  


PCB-00216: OCCURS ASCENDING/DESCENDING clause not allowed for "string"

1 Answers  


ORA-25231: cannot dequeue because CONSUMER_NAME not specified

1 Answers  


Categories