PCC-00132: Indicator array size must not be less than its
host variable



PCC-00132: Indicator array size must not be less than its host variable..

Answer / guest

Cause: An host variable array was used with an indicator
array declared with a smaller dimension. For example: EXEC
SQL BEGIN DECLARE SECTION; int dept_no[20]; short
dept_no_ind[10]; EXEC SQL END DECLARE SECTION; ... SELECT
... INTO dept_no:dept_no_ind ...

Action: Increase the size of the indicator array.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00263: PIECED column string must be last specified column in table string

1 Answers  


RMAN-08016: channel string: starting datafile backupset restore

1 Answers  


ORA-06569: Collection bound by bind_array contains no elements

1 Answers  


NZE-29230: the header length is not sufficient for message header

1 Answers  


PCC-00033: Missing operand for option "string"

1 Answers  






KUP-04021: field formatting error for field string

1 Answers  


PCC-02321: only subtraction between two pointers is permitted

2 Answers  


PCC-02373: Invalid declaration in EXEC SQL DECLARE section

1 Answers  


ORA-00375: unable to get default db_block_size

1 Answers  


ORA-23323: parameter length exceeds deferred RPC limits

1 Answers  


VID-00704: invalid input format

1 Answers  


SQL*Loader-00915: Error closing cursor: [number]

1 Answers  


Categories