Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


PCC-00117: Invalid ARRAYLEN length variable type



PCC-00117: Invalid ARRAYLEN length variable type..

Answer / guest

Cause: A valid array dimension was not specified in an
ARRAYLEN statement. The array 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 ename_array (25); --
illegal dimension

Action: Supply a valid array 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

RMAN-06070: DBWR could not identify datafile string

1 Answers  


ORA-36184: (XSAGGR10) You do not have sufficient permissions for the variable workspace object.

1 Answers  


ORA-16530: invalid buffer or length

1 Answers  


ORA-00273: media recovery of direct load data that was not logged

1 Answers  


KUP-04000: error initializing IO state for file string in string

1 Answers  






ORA-09843: soacon: Archmon unable to create named pipe.

1 Answers  


DRG-11119: operation is not supported by this index type

1 Answers  


ORA-16726: the external condition supplied to resource manager is invalid

1 Answers  


ORA-26032: index string.string loading aborted after string keys

0 Answers  


ORA-29322: SCN string size too long -- maximum size 58 bytes/characters

1 Answers  


EXP-00054: error on row number of subpartition string

1 Answers  


ORA-24384: Application context size is not initialized

1 Answers  






Categories