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
<[EMAIL PROTECTED]> 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).
> **********************************************************************
>
>
