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

NID-00416: Change of database name failed.

1 Answers  


NNL-00501: set|show log_stats_interval [<seconds>] [<server_list>] : set|show the server's statistic counter logging interval

1 Answers  


DRG-11118: object string does not exist

1 Answers  


KUP-04032: internal error string while parsing field string:

1 Answers  


ORA-32642: non-unique cell values from the ORDER BY clause

1 Answers  






ORA-13503: Creating SYSAUX tablespace with invalid attributes

1 Answers  


PCC-02022: Found end of file while scanning a SQL statement

1 Answers  


ORA-03284: datafile string is not a member of tablespace string

1 Answers  


O2F-00338: Illegal or missing package name

1 Answers  


ORA-07606: szprv: $CHKPRO failure

1 Answers  


RMAN-04014: startup failed: string

1 Answers  


ORA-16094: database shutdown during archival operation

1 Answers  


Categories