title: Spring Mybatis - sending array as input parameter to procedure call in mapper.xml
body: <p>I'm using the following code for passing java array to stored procedure </p>
  
  <pre><code>&lt;select id="abcd" parameterType="java.util.Map" statementType="CALLABLE"&gt;
      {call PKG_xyz.PR_cbcd(
          #{p_array,jdbcType=ARRAY,typeHandler=org.apache.ibatis.type.ArrayTypeHandler,mode=IN},
          #{p_ids,jdbcType=INTEGER,mode=IN},
          #{p_comments,jdbcType=VARCHAR,mode=IN},
          #{p_return_code,jdbcType=INTEGER,mode=OUT},
          #{p_msg_out,jdbcType=VARCHAR,mode=OUT}   
      )}
  &lt;/select&gt;
  </code></pre>
  
  <p>here, p_array is my java array. But i'm getting the following error -->
  "<strong>Error setting null for parameter #1 with JdbcType ARRAY . Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLException: Invalid column type: sqlType=2003</strong>"</p>
  
  <p>Could somebody please help....</p>
  
  <p>Thanks in advance...</p>