| |
- Causa
- TRUNCATION OF VALUE WITH LENGTH length OCCURRED FOR hv-or-parm-number
A value that was assigned to a host variable or parameter was truncated.
However, the length of the value that was truncated is too large to be returned in the indicator variable.
This situation can occur when truncation occurs on assignment of:
- a value to a parameter of a remote stored procedure if the value being truncated is greater than 127 bytes.
In this case, the indicator variable will contain a value of 127.
- a LOB value to a host variable if the value being truncated is greater than 32K bytes.
In this case, the indicator variable will contain a value of 32K.
In these cases, the actual length of the truncated value cannot be returned to the application that uses the indicator variable.
The actual length of the value is returned as message token length.
- Ação do sistema
- The assignment was made, but the data was truncated.
- Resposta ao Desenvolvedor
- Change the declaration of hv-or-parm-number to avoid truncation.
SQLSTATE: 01004
|
| |
