ORA-01461 erros on Direct Mode - specific oracle versions
Posted: 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
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