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

RMAN-06095: a backup controlfile must be restored to recover datafile string

1 Answers  


ORA-31081: name not specified for global declaration

1 Answers  


ORA-00236: snapshot operation disallowed: mounted controlfile is a backup

1 Answers  


ORA-02261: such unique or primary key already exists in the table

1 Answers  


TNS-00129: Internal error - Failed to create new community

1 Answers  






RMAN-05510: Duplicate finished

1 Answers  


ORA-13443: GeoRaster metadata SRS error

1 Answers  


ORA-23492: no new sites for extension request "string"

1 Answers  


RMAN-08086: replaced script string

1 Answers  


ORA-19736: can not plug a tablespace into a database using a different national character set

1 Answers  


ORA-16001: database already open for read-only access by another instance

1 Answers  


ORA-10648: Tablespace SYSAUX is not offline

1 Answers  


Categories