ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Esperanza.Echever...@steria.es
Subject question with boolean types..
Date Mon, 26 Jun 2006 06:47:41 GMT
please, can anyone help me?
my problem is calling a stored procedure in ibatis and this function 
called in pl/sql returns a boolean and i don´t know what are the correct 
types in this case to be put in for no obtain an error ...

<parameterMap id="misParametros" class="java.util.HashMap" >
    <parameter property="parametro1" jdbcType="VARCHAR" 
javaType="java.lang.Boolean" mode="OUT"/> 
    <parameter property="parametro2" jdbcType="VARCHAR" 
javaType="java.lang.String" mode="IN"/> 
    <parameter property="parametro3" jdbcType="VARCHAR" 
javaType="java.lang.String" mode="IN"/> 
    <parameter property="parametro4" jdbcType="VARCHAR" 
javaType="java.lang.String" mode="IN"/> 
    <parameter property="parametro5" jdbcType="VARCHAR" 
javaType="java.lang.String" mode="IN"/> 
  </parameterMap>
 <procedure id="ejecutaTieneDuplicados" parameterMap="misParametros" >
    {? = call report.tiene_duplicados(?,?,?,?)}
  </procedure>

the out parameter tells me an error :
DEBUG - {conn-100021} Connection
DEBUG - {pstm-100022} PreparedStatement: {? = call 
report.tiene_duplicados(?,?,?,?)}
DEBUG - {pstm-100022} Parameters: [JOSELUIS, sip97.rep, VCENTRO=90101, 
19-06-2006]
DEBUG - {pstm-100022} Types: [java.lang.String, java.lang.String, 
java.lang.String, java.lang.String]
DEBUG - Initializing, config='org.apache.struts.action.LocalStrings', 
returnNull=true
06/06/26 08:47:37 DaoException
ERROR - Ha ocurrido un error con la base de datos
com.ibatis.dao.client.DaoException: Failed to execute queryForObject - id 
[ejecutaTieneDuplicados], parameterObject [{parametro4=VCENTRO=90101, 
parametro2=JOSELUIS, parametro3=sip97.rep, parametro1=true, 
parametro5=19-06-2006}].  Cause: 
com.ibatis.common.jdbc.exception.NestedSQLException: 
--- The error occurred in 
com/ibatis/sip/persistence/sqlmapdao/sql/Lis.xml. 
--- The error occurred while applying a parameter map. 
--- Check the Lis.misParametros. 
--- Check the statement (update procedure failed). 
--- Cause: java.sql.SQLException: ORA-06550: línea 1, columna 13:
PLS-00382: el tipo de la expresión no es correcto
ORA-06550: línea 1, columna 7:
PL/SQL: Statement ignored


 
 


Esperanza Echeverría de Miguel
Steria España http://www.steria.es
C/Menéndez y Pelayo,3 bis 46010 Valencia
Tel: + 34 96 393 87 50 Fax: +34 96 393 87 51
esperanza.echeverria@steria.es

 
 
Mime
  • Unnamed multipart/related (inline, None, 0 bytes)
View raw message