PCC-00115: Array required here



PCC-00115: Array required here..

Answer / guest

Cause: In an ARRAYLEN statement, the name of a previously
declared host array was not specified. The first host
variable in an ARRAYLEN statement must be an array. The
second host variable, which specifies an array dimension,
must be a 4-byte integer. The correct syntax follows: EXEC
SQL ARRAYLEN host_array (dimension); The ARRAYLEN statement
must appear in the Declare Section along with, but somewhere
after, the declarations of host_array and dimension.

Action: Check the spelling of both identifiers in the
ARRAYLEN statement. If necessary, supply the missing host
array name.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-50801: failed to parse cursor

1 Answers  


DRG-11210: format column must be a char, varchar, or varchar2 type

1 Answers  


RMAN-12001: could not open channel string

1 Answers  


TNS-00091: * Navigator (or navgatr) - will ask the Navigator only

1 Answers  


ORA-12404: invalid privilege string: string

1 Answers  


LPX-00257: invalid children specification in element declaration

1 Answers  


ORA-29359: invalid method name string specified for resource plan string

1 Answers  


TNS-00088: * exit - quit the Interchange controller

1 Answers  


O2F-00319: No OUTTYPE file specified

1 Answers  


ORA-00346: log member marked as STALE

1 Answers  


RMAN-06530: CHANGE ... KEEP not supported for backup set which contains archive logs

1 Answers  


RMAN-03009: failure of string command on string channel at string

1 Answers  


Categories