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

NID-00406: Reversion of database name failed.

1 Answers  


ORA-31047: Could not retrieve resource data at path string

1 Answers  


ORA-00036: maximum number of recursive SQL levels (string) exceeded

1 Answers  


DRG-50916: last document string is less than first document

1 Answers  


ORA-31434: purge is currently running

1 Answers  






ORA-32131: bind data type cannot be changed

1 Answers  


ORA-31399: Cannot contact LDAP server string at port number

1 Answers  


RMAN-08107: channel string: block restore complete

1 Answers  


ORA-26571: %s.string.string: number of arguments (string) does not match replication catalog

1 Answers  


NNL-00914: Forwarding desired on server queries: string

1 Answers  


ORA-01671: controlfile is a backup, cannot make a standby controlfile

1 Answers  


SQL*Loader-00559: error closing file

1 Answers  


Categories