Page 1 of 1

Detect OracleException "Value length exceeds the parameter size" programatically

Posted: Wed 12 Aug 2020 09:50
by 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

Re: Detect OracleException "Value length exceeds the parameter size" programatically

Posted: Thu 20 Aug 2020 12:17
by 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.