How to insert data in CLOB column

[rohank23]

Hi ,

I am trying to insert data into a CLOB column, but I get error of missing comma because my CLOB data value has lot's of comma and other special characters which might need to be escaped. Is there a easier way to do this, without writing code to put escape character before all special characters in CLOB data value.

sStatement.Format(_T("INSERT INTO rktable (rk_clob_col) values (%s),rk_str));

Thanks in advance.

Rohan

[Ancient Dragon]

My guess is that you are using the wrong sql statement. If you are using Oracle then you need to read this article and sample program.

[rohank23]

I am writing the code in C++ and not Java. Sorry, I should have mentioned this earlier. So the artilce which you mentioned talks about Java.