December 16th, 2011, 06:50 AM
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#?
Click Here to Expand Forum to Full Width