Hi Clinton, I saw list of events on the website, is there any
plans visiting New York, in near future,monthly meetings of www.nyjavasig.com/would
be good place to give speech, “Ibatis Does AjAX presentation ” would be a
bliss. (please J )
From: nando.dev
[mailto:[EMAIL PROTECTED]
Sent: Saturday, September 23, 2006 3:41 PM
To: user-java@ibatis.apache.org
Subject: Re: question with boolean types..
Hi Esperanza, the problem do
you have is the type boolean of pl/sql isn´t standard of JDBC, so do you have
to write a wrapper to this function.
2006/6/26, [EMAIL PROTECTED]
<[EMAIL PROTECTED]>:
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
|
