title: call a oracle function that returns a record from mybatis 3
body: <p>i have this function in oracle:</p>
  
  <pre><code>CREATE or replace FUNCTION rmc_getPublicaciones (yearr IN number)
  
  RETURN publicacionisi%ROWTYPE    
  IS
  publtotal publicacionisi%ROWTYPE;
  BEGIN
     SELECT * into publtotal
     FROM publicacionisi p where p.py = yearr;
     RETURN publtotal;
  END;
  </code></pre>
  
  <p>and i want to call it from mybatis and put the result in a resultmap</p>
  
  <pre><code>&lt;select id="getAllPublicaciones"  parameterType="int" statementType="CALLABLE" resultMap="resMapPublicacionIsi" useCache="false"&gt;
           select desa.rmc_getPublicaciones(#{py}) from dual
  &lt;/select&gt;
  </code></pre>
  
  <p>what should i do to make this work?
  i could do the same just using 
  <code>select * from publicacionisi p where p.py={#py}</code> but i wanna see if there is some difference in performance doing this in a function in the database.</p>