ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Diego Umpierre" <di...@umpierre.com.br>
Subject output parameters (register output parameters failed).
Date Mon, 29 Jan 2007 21:16:20 GMT
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

Mime
View raw message