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-26517: materialized view control entry for 'string.string' was not found

1 Answers  


ORA-32056: invalid number of extents

1 Answers  


ORA-28512: cannot get data dictionary translations from string

1 Answers  


ORA-31042: Too many properties in type 'string'

1 Answers  


ORA-02254: DEFAULT <expression> not allowed here

1 Answers  






TNS-02502: Authentication: unable to find initialization function

1 Answers  


ORA-13237: internal error during R-tree concurrent updates: [string]

1 Answers  


ORA-28541: Error in HS init file on line number.

1 Answers   IES,


ORA-02360: fatal error during data export/import initialization

1 Answers  


RMAN-08533: restoring blocks of datafile string

1 Answers  


NZE-29234: a key object was not extracted from encoding

1 Answers  


NNO-00604: disabling all request processing

1 Answers  


Categories