PCB-00578: Variable "string" must be a table



PCB-00578: Variable "string" must be a table..

Answer / guest

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

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-26061: Concurrent direct unloads is not allowed.

1 Answers  


ORA-30725: JDWP-based debugging is not yet available

1 Answers  


RMAN-06557: unable to restore archived log thread number, sequence number

1 Answers  


NNL-01007: VERSION SKEW responses received: number

1 Answers  


ORA-29664: Unable to generate the helper class for the defined type

1 Answers  


QSM-00779: the specified directive conflicts with the existing directive string

1 Answers  


ORA-31505: cannot alter or drop predefined change set

1 Answers  


ORA-38753: Cannot flashback data file string; no flashback log data.

1 Answers  


NZE-28828: invalid identity type passed

1 Answers  


ORA-12731: invalid collation class in regular expression

1 Answers  


TNS-00021: INTCTL: missing INTERCHANGE_DATA in INTCHG.ORA

1 Answers  


ORA-24045: invalid agent address string, agent address should be of the form [SCHEMA.]NAME[@DATABASE LINK]

1 Answers  


Categories