If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register or Login
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Writing to table with xmltype column issue on Oracle

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#?