Devart Forums

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!

We have answered you via e-mail.

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

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

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.

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