Have Geek Brain

How to insert CLOB using OleDb

Can anyone post some sample code showing how to insert text longer than 4000 characters into an Oracle 10g CLOB field? I am using Oracle OLEDB provider and ATL in C ++. My naive attempt returns the error "ORA-01704: string literal too long" whenever the text I am trying to insert contains more than 4000 characters. I guess I need to parameterize the 4000+ character string somehow, but I'm not sure how to do this ...

0


a source to share


1 answer


I ended up getting this job. In case anyone else has a problem, I pasted in the EMPTY_CLOB () value, then used the ISequentialStream interface to stream the text into an empty field. The Microsoft mydyntext example shows how to do this.



0


a source






More articles:


All Articles