title: DB2 - Unable to post 1MB+ clob data in to table via stored procedure - sqlstate-22001
body: <p>We are working on a poc with mule and db2.  We are trying to insert 2 MB of data as CLOB datatype in to table via stored procedure, it is working fine if we post clob data less than or equal to 1 MB.  Issue is when we post 1 MB+ data in the host variable of signature in stored procedure then getting out of range error.  Please find below the error details.  Can anyone advise.</p>
  
  <p>Code:-</p>
  
  <pre><code>&lt;db:stored-procedure config-ref="Configuration"  doc:name="Database"&gt;
      &lt;db:parameterized-query&gt;
          &lt;![CDATA[{CALL TEST(:testData, :OutParam)}]]&gt;
      &lt;/db:parameterized-query&gt;
      &lt;db:in-param name="testData" type="CLOB" value="&lt;&lt;2MB of data&gt;&gt;"/&gt;
      &lt;db:out-param name="OutParam" type="BIGINT"/&gt;
  &lt;/db:stored-procedure&gt;
  </code></pre>
  
  <p>Error</p>
  
  <pre><code>DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.9.110 (com.ibm.db2.jcc.am.SqlDataException).
  </code></pre>