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-13828: generated SQL profile name string already exists

1 Answers  


ORA-12160: TNS:internal error: Bad error number

1 Answers  


ORA-09291: sksachk: invalid device specified for archive destination

1 Answers  


ORA-23423: job number string is not positive

1 Answers  


ORA-16148: user requested expiration of managed recovery operation

1 Answers  






ORA-13031: Invalid Gtype in the SDO_GEOMETRY object for point object

1 Answers  


LCD-00100: internal error, argument [number]

1 Answers  


ORA-07246: sfofi: open error, unable to open database file.

1 Answers  


ORA-03207: subpartitioned type must be specified for composite object

1 Answers  


ORA-08322: scnmin: open/convert of bias lock failed

1 Answers  


NNO-00070: administrative region has changed, reloading domain data

1 Answers  


ORA-09829: pw_createPorts: server call pws_start_instance failed.

1 Answers  


Categories