PCB-00222: Size for host variable string exceeds maximum size



PCB-00222: Size for host variable string exceeds maximum size..

Answer / guest

Cause: A variable declared with PIC S9(n), with n greater
than what is allowed on the given platform, was used in an
embedded sql statement. On 32 bit machines n must not exceed
9, and on 64 bit machines, n must not exceed 18.

Action: Use a smaller number in the picture clause that does
not exceed the maximum allowed size on your platform or use
COMP-3.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14025: PARTITION may not be specified for a materialized view or a materialized view log

1 Answers  


ORA-07476: slsget: cannot get mapped memory statistics.

1 Answers  


LPX-00658: Invalid XSLT object type.

1 Answers  


KUP-04041: error generating full file name for string in string

1 Answers  


O2I-00132: Unable to close a Java file

1 Answers  






ORA-29306: datafile string is not online

1 Answers  


ORA-38716: Must supply an integer for the TYPE option.

1 Answers  


ORA-30382: DROP MATERIALIZED VIEW string.string operation is not complete

1 Answers  


ORA-24144: rules engine internal error, arguments: [string], [string]

1 Answers  


NCR-03025: NCRO: Failed to make LIST connection(s)

1 Answers  


PLS-00458: subprogram 'string' cannot be called from a REPEATABLE subprogram

1 Answers  


IMG-02007: 2FF07 - positional color feature cannot be determined

1 Answers  


Categories