Page 1 of 1

ORA-01461 erros on Direct Mode - specific oracle versions

Posted: Fri 26 Oct 2018 21:07
by tiago.silveira
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

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

Posted: Fri 02 Nov 2018 14:28
by Pinturiccio
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.