Database Software

Hi,

I've met a strange problem in my C# project. I create a table , which includes a XMLType column. Then when I insert some data to it, a ORA-01461 ( can bind LONG only ...balabala... ) error occurs. I've already use OracleParameter to build OracleCommand, and assign the corresponding parameter to Oracle.CLOB type( there is no XMLType in my VS2008 ).

I don't know how to fix it. But I try to modify the column type to CLOB, to my surprise, it works. And then I tried NCLOB, because I need to storage some Chinese characters.

So I wonder to know what's the difference between XMLType and CLOB(or NCLOB), why my code can works after change the column type?


My environment:
Server : Oracle 10.2
Client : Oracle Client 10.2
Language: C# with .Net framework 2.0
Data : some xml string with 5000+ ANSI characters

Thanks a lot .