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

LFI-00108: Open expect the file [string][string] to exist.

1 Answers  


DRG-12803: invalid text datatype

1 Answers  


NZE-29115: Cannot export private key.

1 Answers  


ORA-27011: skgfrd: cannot read from file opened for write

1 Answers  


ORA-40220: maximum number of attributes exceeded

1 Answers  






ORA-01049: Bind by name is not spupportted in streamed RPC

1 Answers  


NZE-29024: Certificate validation failure

1 Answers  


ORA-17610: file 'string' does not exist and no size specified

1 Answers  


DRG-11003: invalid value string for string

1 Answers  


NNF-03004: DNS Class mismatch (string)

1 Answers  


ORA-30198: reserved for future use

1 Answers  


ORA-14103: LOGGING/NOLOGGING may not be combined with RECOVERABLE/UNRECOVERABLE

1 Answers  


Categories