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-38415: invalid name or datatype for the attribute: string

1 Answers  


PLW-05000: mismatch in NOCOPY qualification between specification and body

1 Answers  


ORA-16170: Terminal recovery may have left the database in an inconsistent state

1 Answers  


TNS-04010: Command cannot be issued before the ADMINISTER command.

1 Answers  


SQL*Loader-00105: Invalid data file name on command line

1 Answers  


ORA-01879: the hh25 field must be between 0 and 24

1 Answers  


PCB-00628: Buffer type is incompatible with LOB type

1 Answers  


ORA-36634: (XSDUNION02) INTEGER dimension workspace object cannot be used as a concat dimension base.

1 Answers  


TNS-00501: Cannot allocate memory

1 Answers  


ORA-25504: the system is already in quiesced state

1 Answers  


ORA-33468: (ESDREAD13) Discarding compiled code for workspace object because number is no longer a surrogate of dimension workspace object.

1 Answers  


ORA-30745: error occured while trying to add column "string" in table "string"

1 Answers  


Categories