How do you generate your SQL..

I use either a BLOB,CLOB or Varchar2(4000)..

I do it like this...

cString='A very,very,very.....long string'
SQLEXEC(h,'update mytable set myfield=?cString')