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-13426: invalid window parameter for subset operation

1 Answers  


ORA-36994: (XSRELGID11) The SURROGATE DIMENSION workspace object must be numeric.

1 Answers  


ORA-12045: invalid ALTER MATERIALIZED VIEW LOG option

1 Answers  


ORA-31461: logfile location string contains no files that match pattern string

1 Answers  


ORA-12719: operation requires database is in RESTRICTED mode

2 Answers  






ORA-06522: %s

1 Answers  


ORA-12216: TNS:poorly formed PREFERRED_CMANAGERS addresses in TNSNAV.ORA

1 Answers  


ORA-09776: pws_look_up: access error on (Oracle helper) executable

1 Answers  


ORA-22952: Nested Table equality requires a map method on the element ADT

1 Answers  


DRG-50601: fatal error

1 Answers  


PLS-00523: ORDER methods must return an INTEGER.

1 Answers  


ORA-31154: invalid XML document

1 Answers  


Categories