title: ORA-22295 processing clob and long together
body: <p>I'm trying to load 2 clob and one long column in a single insert statement. I'm getting error message as </p>
  
  <blockquote>
    <p>ORA-22295: cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement.</p>
  </blockquote>
  
  <p>After browsing about this error code I understood that we can't process clob and long data type together. Either one long or all/any clob can only be processed in a single statement. So Does this mean I have to first insert for all my clob columns and following that I have to trigger an update sql to load the long column. Please advise me in this.</p>
  
  <p>I dont have the source code as I'm processing the rows using data stage etl tool.</p>