title: Java.sql.SQLException: operation not allowed with Oracle procedure and mybatis
body: <p>I am using Mybatis with springboot to connect with an Oracle database. In that process I need to update multiple fields in bulk. </p>
  
  <p>I have created a procedure to implement that functionality on the database side. When calling that procedure from the DAO layer, the following exception occurs:</p>
  
  <blockquote>
    <p>org.springframework.jdbc.UncategorizedSQLException:<br>
    Error getting generated key or setting result parameter object.<br>
    Cause<br>
    Java.sql.SQLException: operation not allowed.</p>
  </blockquote>
  
  <pre><code>&lt;insert id="update" parameter="java.util.map" statement="callable"&gt;
  { call test.bulk_update_procedure(#{customerid, mode=IN , jdbcType= varchar},#{firstname, mode= IN, jdbcType= varchar},#{age,mode=IN, jdbcType=varchar})
  &lt;/insert&gt;
  </code></pre>