ibastis Oracle stored procedure

[dobrobuz]

Hi,
I need to call an oracle stored procedure with iBatis 2.3.* that return 2 output parameter (number, varchar2).

This is the header of procedure

PROCEDURE PROC_TEST(parmIN1 in varchar2, parmIN2 in varchar2, error in number, msg_error in varchar2)

This is the SQLMap

	<typeAlias alias="parametersIN" type="class1"/>
	<typeAlias alias="resultOUT" type="class2"/>

	<parameterMap id="parametersINMap" class="parametersIN">
		<parameter property="paramIN1" jdbcType="VARCHAR" mode="IN" />
		<parameter property="paramIN2" jdbcType="VARCHAR" mode="IN" />	
		<parameter property="esitoAggiornamento" jdbcType="NUMERIC" mode="OUT" resultMap="esitoProceduraCaricoEmoderivati" />
		<parameter property="messaggioErrore" jdbcType="VARCHAR" mode="OUT" resultMap="esitoProceduraCaricoEmoderivati" />
	</parameterMap>
	
	<resultMap class="result" id="resultOUT">
		<result property="error" jdbcType="NUMERIC" column="col12" javaType="int" />
		<result property="msg_error" jdbcType="VARCHAR" column="col13" javaType="string" />
	</resultMap>
	
	<procedure id="test" parameterMap="parametersINMap" >
		{CALL PROC_TEST(?, ?, ?, ?)}
	</procedure>

but doesn't work

I need to map the result in a JAVA object and the parameter's Map into another JAVA object.

Thanks for help

[dobrobuz]

Sorry I've forgot to write the Spring Version.


Spring Framework 3.0.2
Spring Security 3.0.2