Parameter too long error message

alexB · Post by **alexB** » Fri 09 Sep 2011 09:14

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] ?

Shalex · Post by **Shalex** » Mon 12 Sep 2011 15:26

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.

alexB · Post by **alexB** » Fri 16 Sep 2011 13:32

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

Thank you,

Alex.

Shalex · Post by **Shalex** » Tue 20 Sep 2011 11:53

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.

Shalex · Post by **Shalex** » Thu 22 Sep 2011 16:06

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.

Shalex · Post by **Shalex** » Fri 30 Sep 2011 13:21

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 .