Announcement Announcement Module
Collapse
No announcement yet.
ibastis Oracle stored procedure Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • ibastis Oracle stored procedure

    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
    Code:
    PROCEDURE PROC_TEST(parmIN1 in varchar2, parmIN2 in varchar2, error in number, msg_error in varchar2)
    This is the SQLMap
    Code:
    	<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
    Last edited by dobrobuz; Jun 9th, 2010, 10:34 AM.

  • #2
    Sorry I've forgot to write the Spring Version.


    Spring Framework 3.0.2
    Spring Security 3.0.2

    Comment

    Working...
    X