ORA-01461 erros on Direct Mode - specific oracle versions

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
tiago.silveira
Posts: 1
Joined: Fri 26 Oct 2018 20:20

ORA-01461 erros on Direct Mode - specific oracle versions

Post by tiago.silveira » Fri 26 Oct 2018 21:07

On Version number: 9.6.621.0 we are facing exceptions on the following case:

executing update commands with multiple parameters where one of this parameter is a huge text being saved on a column of type 'Long' or of type 'CLOB'.

>>>>
on oracle version 12.2.0.1.0


no errors

>>>>
on oracle version 12.1.0.2.0

if the text has lots of characters (>4000)
we get the exception when using OracleDbType.VarChar or OracleDbType.Long

if the text has fewer character (<4000)
we get the exception when using OracleDbType.Long

>>>>
on oracle version 11.2.0.1.0
if the text has lots of characters (>4000)
we get the exception when using OracleDbType.VarChar

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: ORA-01461 erros on Direct Mode - specific oracle versions

Post by Pinturiccio » Fri 02 Nov 2018 14:28

Sorry for the late response. We have received your test project, and we are processing your request. We will post here about the results as soon as possible.

Post Reply