Parameter too long error message

Parameter too long error message

Postby 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 support@devart.com ?
alexB
 
Posts: 15
Joined: Fri 30 Apr 2010 11:06

Postby 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.
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44

Postby alexB » Fri 16 Sep 2011 13:32

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

Thank you,

Alex.
alexB
 
Posts: 15
Joined: Fri 30 Apr 2010 11:06

Postby 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
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44

Postby 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
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44

Postby 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 .
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle