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] ?
Parameter too long error message
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.
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.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.
We will implement the corresponding exception in the Direct mode as soon as possible and notify you about it.
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 .
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 .