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-06311: IPA: Maximum number of servers reached

1 Answers  


ORA-06546: DDL statement is executed in an illegal context

1 Answers   Oracle,


ORA-32332: cannot refresh materialized view "string"."string" as type evolution has occured

1 Answers  


IMG-00899: signature cannot be generated

1 Answers  


KUP-04059: found EOF in length portion of VARIABLE record in file string

1 Answers  






RMAN-06534: KEEP ... CONSISTENT option is not supported

1 Answers  


ORA-31416: invalid SOURCE_COLMAP value

1 Answers  


ORA-01127: database name 'string' exceeds size limit of string characters

1 Answers  


SQL*Loader-00468: OID directive expects 1 argument, number found.

1 Answers  


RMAN-05514: tablespace string has undo information, cannnot skip

1 Answers  


ORA-09883: Two Task interface: oratab file does not exist

1 Answers  


ORA-27025: skgfqsbi: invalid media manager context area size

1 Answers  


Categories