Detect OracleException "Value length exceeds the parameter size" programatically

[hansjoergp]

Is there any possiblity to detect an OracleException with an message "Value length exceeds the parameter size" without comparing the message text? The errorcode is 0x80004005

Best regards
Hansjörg

[Shalex]

1. You can turn off the generation of the "Value length exceeds the parameter size" error. For this, specify this line of code only once in your application (silent truncation):

Code: Select all

    OracleUtils.ParameterValueTrimming = true;

2. We will investigate the possibility to assign unique ErrorCode for this exception.