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

KUP-04080: directory object string not found

1 Answers  


ORA-19616: output filename must be specified if database not mounted

1 Answers  


ORA-24123: feature string is not yet implemented

1 Answers  


ORA-01677: standby file name convert parameters differ from other instance

1 Answers  


ORA-02191: correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT <rbs>

1 Answers  


ORA-16640: CRS warns that multiple instances may still be running.

1 Answers  


ORA-29303: user does not login as SYS

1 Answers  


ORA-12542: TNS:address already in use

1 Answers  


ORA-01532: cannot create database; instance being started elsewhere

1 Answers  


TNS-00534: Failed to grant connection ownership to child

2 Answers  


ORA-32576: missing TYPE keyword

1 Answers  


ORA-39142: incompatible version number string in dump file "string"

1 Answers  


Categories