title: Mybatis, insert in Oracle with sequence id
body: <p>I have tried with this:</p>
  
  <pre><code>&lt;insert id="insertPersonalizacionUsuario" useGeneratedKeys="true" keyProperty="param1.id" keyColumn="id"&gt;
      INSERT INTO dsk_prop_personali (idpersonalizacion, idusuario, valor, centro) 
      VALUES (#{param1.idPersonalizacion}, #{param1.idUsuario}, #{param1.valor}, #{param2})
  </code></pre>
  
  <p></p>
  
  <p>And with this:</p>
  
  <pre><code>&lt;insert id="insertPersonalizacionUsuario" useGeneratedKeys="true"          keyProperty="param1.id" keyColumn="id"&gt;
      &lt;selectKey keyProperty="id" resultType="int"&gt; 
           SELECT id.nextVal from dual 
      &lt;/selectKey&gt; 
      INSERT INTO dsk_prop_personali (id, idpersonalizacion, idusuario, valor, centro) 
      VALUES (#{id}, #{param1.idPersonalizacion}, #{param1.idUsuario}, #{param1.valor}, #{param2})
  </code></pre>
  
  <p></p>
  
  <p>But not working. Thanks</p>