Hi Everyone, my C# code writes to a column in a table in Oracle database. When the contents are more than 4000 characters, it throws an error saying
ORA-01461: can bind a LONG value only for insert into a LONG column.
Less than that, it works. I bind the column as ntext type because I am using System.Data.OracleClient to communicate with Oracle db and it does not recognize xmltype column but does recognize ntext.

I also have C++ code that writes to database using ODBC apis. I have tried the same with it and get the same error.

Has anyone seen or tried this? Any idea about handling xmltype column in C#?

TIA