PCB-00230: Indicator table size must not be less than its
host variable



PCB-00230: Indicator table size must not be less than its host variable..

Answer / guest

Cause: An host variable table was used with an indicator
table declared with a smaller dimension. For example: EXEC
SQL BEGIN DECLARE SECTION END-EXEC. 01 EMP-NUM OCCURS 4
TIMES PIC S9(4) COMP. 01 EMP-NUM-IND OCCURS 2 TIMES PIC
S9(4) COMP. EXEC SQL END DECLARE SECTION END-EXEC. ...
SELECT ... INTO EMP-NUM:EMP-NUM-IND ...

Action: Increase the size of the indicator table.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-19691: %s is from different database: id=string, name=string

1 Answers  


NNL-00201: Shutdown occurs in string

1 Answers  


ORA-16565: duplicate property, syntax error at "string"

1 Answers  


ORA-28166: duplicate rolename in list

1 Answers  


ORA-13454: GeoRaster metadata is invalid

1 Answers  






ORA-07576: sspexst: $GETJPIW failure on process ID string

1 Answers  


SQL*Loader-00282: Unable to locate character set handle for character set ID (number).

2 Answers  


ORA-04062: %s of string has been changed

1 Answers  


ORA-15074: diskgroup string requires rebalance completion

1 Answers  


RMAN-06452: %s package upgraded to version string

1 Answers  


ORA-14030: non-existent partitioning column in CREATE TABLE statement

1 Answers  


TNS-00317: Failed to contact Connection Manager

1 Answers  


Categories