Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

ORA-07263: sptpa: kill error.

1 Answers  


ORA-16162: Cannot add new standby databases to protected configuration

1 Answers  


ORA-22955: The cardinality parameter is not within the allowed limits

1 Answers  


NNL-00812: Slowest query processing time: string

1 Answers  


O2I-00101: Invalid value for the USERID parameter

1 Answers  






ORA-14640: add/coalesce index partition operation is valid only for hash partitioned global indexes

1 Answers  


PLS-01401: Identifier over 18 characters long

1 Answers  


ORA-24124: invalid ACTION parameter passed to DBMS_REPAIR.string procedure

1 Answers  


ORA-15095: reached maximum ASM file size (string GB)

1 Answers  


NID-00603: No datafiles found in database

1 Answers  


NNL-00307: Server checkpointing its cache

1 Answers  


ORA-27043: unable to seek to beginning of file

1 Answers  






Categories