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-22899: cannot specify both scope and rowid constraint on ref column

1 Answers  


PROT-00011: Failed to open the specified destination cluster registry

1 Answers  


TNS-00090: * Interchange - will ask the Interchange

1 Answers  


ORA-03279: invalid INSTANCE specified

1 Answers  


PLS-00519: This INSERT statement requires a VALUES clause containing an object type expression, not a list of values

1 Answers  






ORA-36393: (XSMXCLEA03) When using the CHANGES or CACHE options, you must specify the ALL keyword.

1 Answers  


ORA-12526: TNS:listener: all appropriate instances are in restricted mode

1 Answers  


ORA-24126: invalid CASCADE_FLAG passed to DBMS_REPAIR.string procedure

1 Answers  


TNS-04203: Trace Assistant Usage ERROR: Invalid options

1 Answers  


PLS-01407: One of the identifiers CHAR, CHARACTER, or INTEGER has been redefined by the programmer

1 Answers  


CLSS-02001: local node number string, master node number string

1 Answers  


ORA-19004: Duplicate XMLType OBJECT RELATIONAL storage option

1 Answers  


Categories