Devart Forums

Hello,

If i send a Parameter value too long for the type OracleDbType.NVarChar, within a StoredProcedure (using Direct=True in my ConnectionString) i get an exception message like:

"ORA-20000: silent failure in parameter passing - bad: 4000ORA-06512: at "Test.Test_LONG_TEXT_PARAMETER", line 7ORA-06512: at line 2"

I expect a more detailed diagnostic message, something like "it is not possible to fit the data into a NVarChar", which points me to the problem.

Could you fix this ?

I am using dotConnect version 6.30.185.

Here are some infos about my Oracle

Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
PL/SQL Release 10.2.0.1.0 - Production
"CORE 10.2.0.1.0 Production"
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production


I also prepared a test project so that you can reproduce it on your machine. Should i send it to the [email protected] ?

Please send your test project via our contact form (include the link to this post in the Detailed Info section): http://www.devart.com/company/contact.html.

I just sent you the test project. I wait for your response.

Thank you,

Alex.

alexB wrote:I expect a more detailed diagnostic message, something like "it is not possible to fit the data into a NVarChar", which points me to the problem.

The OCI mode (via Oracle client) throws "Value length exceeds the parameter size" if parameter size is greater than 4000 bytes. Please use OCI mode as a temporary workaround.

We will implement the corresponding exception in the Direct mode as soon as possible and notify you about it.

The bug with silent truncation of NVarChar parameter in Direct mode is fixed. We will post here when the corresponding build of dotConnect for Oracle is available for download.

New build of dotConnect for Oracle 6.50.228 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=22164 .