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

ORA-00340: IO error processing online log string of thread string

2 Answers   ABC,


QSM-02090: SELECT includes an expression that is not just a column

1 Answers  


NNL-01009: Outbound message contexts freed: number

1 Answers  


ORA-00263: there are no logs that need archiving for thread string

1 Answers  


ORA-38756: Flashback is already turned off for this tablespace.

1 Answers  






ORA-06970: X.25 Driver: remote host is unknown

1 Answers  


ORA-01881: timezone region id number is invalid

1 Answers  


ORA-06310: IPA: Environment variable(s) not set

1 Answers  


LPX-00210: expected '~1c' instead of '~2c'

1 Answers  


PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted

1 Answers  


ORA-24127: TABLESPACE parameter specified with an ACTION other than CREATE_ACTION

1 Answers  


ORA-14178: STORE IN (DEFAULT) clause is not supported for hash partitioned global indexes

1 Answers  


Categories