PCC-00117: Invalid ARRAYLEN length variable type



PCC-00117: Invalid ARRAYLEN length variable type..

Answer / guest

Cause: A valid array dimension was not specified in an
ARRAYLEN statement. The array dimension must be specified
using a previously declared 4-byte integer host variable,
not a literal or expression. For example, the offending code
might look like: EXEC SQL ARRAYLEN ename_array (25); --
illegal dimension

Action: Supply a valid array dimension. If necessary,
declare a 4-byte integer host variable for use in the
ARRAYLEN statement.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06049: CHECK LOGICAL option not supported for archive log or current/standby controlfile copies

1 Answers  


DRG-12431: configuration section string not found

1 Answers  


DRG-13103: index table string is partitioned

1 Answers  


ORA-13288: point coordinate transformation error

1 Answers  


ORA-22870: ALTER TYPE with REPLACE option a non-object type

1 Answers  






ORA-19559: error sending device command: string

1 Answers  


NCR-04009: NCRR: Object exists

1 Answers  


QSM-01618: equivalence, string, is enabled for text match rewrite only

1 Answers  


ORA-16749: Resource guard encountered errors in switchover to logical primary

1 Answers  


ORA-02756: osnfsmnam: name translation failure

1 Answers  


ORA-25118: invalid DUMP DATAFILE/TEMPFILE option

1 Answers  


ORA-32575: Explicit column default is not supported for modifying views

1 Answers  


Categories