In this post, you’ll learn more about the Oracle ErrorPCB-00230: Indicator table size must not be less than its host variable with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PCB-00230: Indicator table size must not be less than its host variable
Reason for the Error PCB-00230: Indicator table size must not be less than its host variable
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 …
How to fix the Error PCB-00230: Indicator table size must not be less than its host variable ?
You can fix this error in Oracle by following the below steps
Action: Increase the size of the indicator table.