PCB-00230: Indicator table size must not be less than its
host variable
- 1 Answers
- 2220 Views
- I also Faced
- E-Mail Answers
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 |
ORA-02297: cannot disable constraint (string.string) - dependencies exist
ORA-13418: null or invalid parameter(s) for set functions
TNS-12650: No common encryption or data integrity algorithm
DRG-12434: connection failed using configuration string information
RMAN-20006: target database name is missing
KUP-04055: column string is both a field in the data file and a column transform
ORA-23532: tables with different synchronization mechanisms are in the same group
PCC-00016: Unable to open a cursor at line number in file string
ORA-09212: sfwfbmt: error writing to file
DRG-13002: preference string is not a MULTI_LEXER
ORA-31499: null value specified for required parameter string
ORA-23495: serial propagation can not be used for "string"
Oracle Errors 
