Can't update a LONG column with more than 8000 char

[gcaram]

Hello,
I got a ORA-01461 while trying to update a Long column in a table with a Devart.Data.Oracle.OracleDbType.Long as a parameter.
It works until the version 9.5.454 it's possible, from the version 9.5.483 up to the actual 9.6.570 it throws the exception ORA-01461.
It also works in the newers versions if i use Devart.Data.Oracle.OracleDbType.VarChar for parameters if the size is less than 8.000. But obvious it doesn't resolve, since i have records with size of 130.000 in this column.

By the way, I can't change the column from Long to Clob.

Hope you guys will sort it out!

[Pinturiccio]

We have answered you via e-mail.

[gcaram]

I replied your email, please let me know when you got some news.

[Pinturiccio]

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

[Pinturiccio]

We have fixed the bug with the ORA-01461 error when a LONG parameter is used in the Direct mode for Oracle 12. We will post here when the corresponding build of dotConnect for Oracle is available for download.

[Pinturiccio]

New build of dotConnect for Oracle 9.6.597 is available for download.
It can be downloaded from https://www.devart.com/dotconnect/oracle/download.html (trial version) or from Customer Portal (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=37715