PCB-00579: Invalid ARRAYLEN length variable type for "string"



PCB-00579: Invalid ARRAYLEN length variable type for "string"..

Answer / guest

Cause: A valid table dimension was not specified in an
ARRAYLEN statement. The table 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 ETABLE (25) END-EXEC. --
illegal dimension

Action: Supply a valid table 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-38101: Invalid column in the INSERT VALUES Clause: string

1 Answers  


ORA-29965: The specified binding does not exist

1 Answers  


IMP-00041: Warning: object created with compilation warnings

1 Answers  


ORA-06554: package DBMS_STANDARD must be created before using PL/SQL

1 Answers  


ORA-07202: sltln: invalid parameter to sltln.

1 Answers  






SQL*Loader-00276: Local storage option overrides global storage.

1 Answers  


ORA-02208: duplicate MAXTRANS option specification

1 Answers  


ORA-24355: attempt to store a negative number in an Unsigned Display type.

1 Answers  


ORA-06713: TLI Driver: error on connect

1 Answers  


RMAN-20241: ambiguous archived log name

1 Answers  


ORA-14267: cannot specify PARALLEL clause when adding a (Composite) Range partition

1 Answers  


NNL-00582: dump_alias: dump aliases in the domain or region to LDAP

1 Answers  


Categories