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

PLS-00561: character set mismatch on value for parameter 'string'

1 Answers  


ORA-12853: insufficient memory for PX buffers: current stringK, max needed stringK

1 Answers  


ORA-03234: unable to extend index string.string subpartition string by string in tablespace string

1 Answers  


ORA-07595: sppid: $GETJPIW failure

1 Answers  


ORA-24026: operation failed, queue string.string has errors

1 Answers  






PCB-00208: Incorrect type for host variable "string"

1 Answers  


IMP-00040: FILESIZE does not match the value used for export: string

1 Answers  


ORA-13347: the coordinates defining an arc are not distinct

1 Answers  


ORA-27415: repeat interval must start with the FREQ= clause

1 Answers  


ORA-13212: failed to compare tile with the window object

1 Answers  


ORA-19568: a device is already allocated to this session

1 Answers  


ORA-24041: propagation schedule exists for QUEUE string and DESTINATION string

1 Answers  


Categories