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 [EMAIL PROTECTED] |
