ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dooley, Liam" <Liam.Doo...@agriculture.gov.ie>
Subject Problems with registering OUT parameter in Oracle stored procedure
Date Tue, 21 Dec 2004 16:36:19 GMT
Hi, 

Has anyone successfully executed an Oracle stored procedure that returns a result set with
multiple columns using ibatis?
We have a stored procedure that returns a result set which contains data for populating a
custom object. This result set is returned as a REFCURSOR and so needs to be registered as
an OUT parameter of type oracle.jdbc.driver.OracleTypes.CURSOR by ibatis?, but it's not clear
to me how to achieve this.
Does anybody know if ibatis can handle this scenario and if so how would i implement it?

This is the current configuration which gives the following error ("--- Check the output parameters
(register output parameters failed).
--- Cause: java.sql.SQLException: Invalid column type"):

  <parameterMap id="customerDetailsByIdParams" class="map">
  	<parameter property="applicantDetails" javaType="ApplicantDetails" mode="OUT"/>
  	<parameter property="foNumber" jdbcType="NUMERIC" javaType="long" mode="IN"/>
  	<parameter property="roleType" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
  </parameterMap>
  
  <procedure id="getCustomerDetailsById" resultMap="customerDetailsByIdResult" parameterMap="customerDetailsByIdParams">
	  	{ CALL ? := PKCO_01_BCUS_DETAILS_GET.bcus_details_get(?,?) }
  </procedure>


**********************************************************************
***********  Department of Agriculture and Food ***************

The information contained in this email and in any
attachments is confidential and is designated solely
for the attention and use of the intended recipient(s).
This information may be subject to legal and professional
privilege.  If you are not an intended recipient of
this email, you must not use, disclose, copy,
distribute or retain this message or any part of it.
If you have received this email in error, please
notify the sender immediately and delete all copies of
this email from your computer system(s).
**********************************************************************


Mime
View raw message