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-00508: The expression in a RETURN statement cannot be a type

1 Answers  


DRG-11850: Transformation Applied

1 Answers  


NZE-28790: NLS string open failure

1 Answers  


SQL*Loader-00965: Error number disabling constraint string on table string

1 Answers  


ORA-12550: TNS:syntax error

1 Answers  






ORA-14031: partitioning column may not be of type LONG or LONG RAW

1 Answers  


ORA-12804: parallel query server appears to have died

1 Answers  


ORA-39112: Dependent object type string skipped, base object type string creation failed

1 Answers  


ORA-01154: database busy. Open, close, mount, and dismount not allowed now

1 Answers  


ORA-10575: Give up restoring recovered datafiles to consistent state: out of memory

1 Answers  


ORA-38482: no elementary attributes defined in the attribute set

1 Answers  


TNS-12625: TNS:missing argument

1 Answers  


Categories