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-10576: Give up restoring recovered datafiles to consistent state: some error occurred

1 Answers  


ORA-12845: failed to receive interinstance parallel execution message

1 Answers  


ORA-06005: NETASY: dialogue file read failure

1 Answers  


ORA-25241: cannot change correlation ID from string to string without FIRST_MESSAGE option

1 Answers  


PCC-00078: FIPS warning: Invalid ANSI SQL Identifier

1 Answers  


ORA-09366: Windows 3.1 Two-Task driver unable to allocate shared memory

1 Answers  


CLSR-01007: Connection to database was not established

1 Answers  


NPL-00100: cannot initialize ASN.1 context

1 Answers  


UDI-00053: unrecognized client command 'string'

1 Answers  


ORA-14095: ALTER TABLE EXCHANGE requires a non-partitioned, non-clustered table

1 Answers  


ORA-13000: dimension number is out of range

1 Answers  


ORA-16132: An error occurred during activation of the standby.

1 Answers  


Categories