output parameters (register output parameters failed).

[Diego Umpierre]

Hi all,


My problem is:

com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in
br/com/lojasrenner/logistica/legadoebs/dao/integra_nt/mapping/ProcExecEbsDAOintegra_nt.xml.

--- The error occurred while executing query procedure.
--- Check the {call RN_AR_001_P(?,?,?, ?)}.
--- Check the output parameters (register output parameters failed).
--- Cause: java.sql.SQLException: Tipo de coluna inválido (column type not
valid)
Caused by: java.sql.SQLException: Tipo de coluna inválido

my xml register and call is:

   <parameterMap id="parameters" class="Map" >
       <parameter property="codEmitenteSessao" jdbcType="INT"
javaType="java.lang.Integer"  mode="IN"/>
       <parameter property="data"              jdbcType="DATE"
javaType="java.util.Date"     mode="IN"/>
               <parameter property="numIdentificador"  jdbcType="INT"
javaType="java.lang.Integer"   mode="IN"/>
       <parameter property="paramOut"          jdbcType="BOOLEAN"
javaType="java.lang.Boolean"   mode="OUT"/>

   </parameterMap>

       <resultMap id="result_consome" class="ProcExecEbs">
           <result property="executeErro" />
       </resultMap>

   <procedure id="consome" resultMap="result_consome"
parameterMap="parameters">
       {call RN_AR_001_P(?,?,?, ?)}
   </procedure>

the procedure in oracle is:

create or replace PROCEDURE rn_ar_001_p
 (P_ORIGEM_NF          In   NUMBER
 ,P_DAT_PADRAO_EMI_NF  In   DATE
 ,P_NUMERO_PLANILHA    In   NUMBER
 ,P_RESULTADO          OUT  Boolean)
AS
  BEGIN
     P_RESULTADO := TRUE;
  END RN_AR_001_P;



So anyone can help me ?


--
Diego Umpierre