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

CLSS-01200: skgxn errror: category string, operation string, loc string

1 Answers  


NZE-28840: Wallet is already open.

1 Answers  


ORA-14103: LOGGING/NOLOGGING may not be combined with RECOVERABLE/UNRECOVERABLE

1 Answers  


TNS-12680: Native services disabled but required

1 Answers  


ORA-31088: object "string"."string" depends on the schema

1 Answers  


RMAN-06412: no proxy copy channel found

1 Answers  


DRG-50600: assertion failed

1 Answers  


PCC-02450: Cursor was not declared in scrollable mode

1 Answers  


RMAN-12011: multiple records for default device type found in catalog

1 Answers  


SQL*Loader-00266: Unable to locate character set handle for string.

1 Answers  


NNL-01056: Requests forwarded: number

1 Answers  


PCC-02020: Preprocessor error at line number, column number, file string:

1 Answers  


Categories