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

DRG-10598: invalid parallel operation

1 Answers  


PLS-00950: In this version, PL/SQL tables can not be used in this SQL statement.

1 Answers  


DRG-10840: CONTAINS predicate including 0 is not supported by FIRST_ROWS hint

1 Answers  


PCC-01018: Conversion buffer size can only be specified for character types

1 Answers  


EXP-00023: must be a DBA to do Full Database or Tablespace export

1 Answers  






ORA-07630: smpdal: $DELTVA failure

1 Answers  


ORA-14008: missing THAN keyword

1 Answers  


DGM-16911: Warning:

1 Answers  


ORA-33098: (APABBR01) A value of 'string' is not valid for the workspace object option.

1 Answers  


SQL*Loader-00809: error dropping sequence: string

1 Answers  


ORA-31069: Cannot apply typed changes to non-schema-based XMLType nodes

1 Answers  


DRG-10819: could not open contains cursor

1 Answers  


Categories