Member Avatar for 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

  • 2 Contributors
  • 2 Replies
  • 109 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by rohank23
Member Avatar for 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.

Member Avatar for 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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.