ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: Problems with registering OUT parameter in Oracle stored procedure
Date Wed, 22 Dec 2004 15:28:55 GMT
Ref cursors are not supported.  They can be implemented with a custom
type handler, but not for an output parameter.  Try using
jdbcType="OBJECT" and javaType="java.lang.Object".


Clinton

On Tue, 21 Dec 2004 16:36:19 -0000, Dooley, Liam
<Liam.Dooley@agriculture.gov.ie> wrote:
> 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