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

PCB-00502: This statement can only be used with THREADS=YES

1 Answers  


ORA-13906: The tablepace is not of the right type.

1 Answers  


IMP-00099: Warning: The typeid in the dump file for object type "string"."string" is invalid

1 Answers  


ORA-00295: datafile/tempfile number string is invalid, must be between 1 and string

1 Answers  


ORA-12689: Server Authentication required, but not supported

1 Answers  






ORA-24354: number fetched too large to fit in COBOL display type buffer.

1 Answers  


NZE-28791: certificate verification failure

1 Answers  


ORA-06002: NETASY: port read failure

1 Answers  


ORA-29520: name string resolved to a class in schema string that could not be accessed

1 Answers  


ORA-32617: missing MEASURES keyword in MODEL clause

1 Answers  


ORA-01090: shutdown in progress - connection is not permitted

1 Answers  


ORA-14017: partition bound list contains too many elements

1 Answers  


Categories