All Oracle Error CodesOracle DBA Forum


Size for host variable string exceeds maximum size
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.