Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 26975 invoked from network); 22 Apr 2009 11:33:12 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 22 Apr 2009 11:33:12 -0000 Received: (qmail 89260 invoked by uid 500); 22 Apr 2009 11:33:10 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 89203 invoked by uid 500); 22 Apr 2009 11:33:10 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 89195 invoked by uid 99); 22 Apr 2009 11:33:10 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Apr 2009 11:33:10 +0000 X-ASF-Spam-Status: No, hits=-1.8 required=10.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [205.194.19.86] (HELO scmze002.ssan.egs-seg.gc.ca) (205.194.19.86) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Apr 2009 11:33:00 +0000 X-SBRS: 2.9 Received: from inbound.hc-sc.gc.ca (HELO nav99.hc-sc.gc.ca) ([205.193.93.11]) by scmze000.ssan.egs-seg.gc.ca with SMTP; 22 Apr 2009 11:32:39 +0000 Received: from smta00.hc-sc.gc.ca ([10.224.40.191]) by nav99.hc-sc.gc.ca (SMSSMTP 4.1.0.19) with SMTP id M2009042207323909989 for ; Wed, 22 Apr 2009 07:32:39 -0400 To: user-java@ibatis.apache.org Subject: cannot retrieve a blob using a callable statement. MIME-Version: 1.0 X-Mailer: Lotus Notes Release 6.5.5 CCH2 April 14, 2006 Message-ID: From: Dean Murray Date: Wed, 22 Apr 2009 07:32:37 -0400 X-MIMETrack: Serialize by Router on SMTA00/HC-SC/GC/CA(Release 8.0.2 HF710|February 09, 2009) at 2009-04-22 07:32:55 AM, Serialize complete at 2009-04-22 07:32:55 AM Content-Type: multipart/alternative; boundary="=_alternative 003F6901852575A0_=" X-Virus-Checked: Checked by ClamAV on apache.org This is a multipart message in MIME format. --=_alternative 003F6901852575A0_= Content-Type: text/plain; charset="US-ASCII" Note: If this is the second time this email appears, I sent this before I registered so I am not sure if the first one got through. Hi I am using IBATIS 2.3 in a Spring Framework and the stored procedure is in a Oracle 10g database. The error I get is Retrieving LOBs from a CallableStatement is not supported; . Is there a way to retrieve BLOBS using a callable statement. I was able to do it using a select but now I need to make this stored procedure call. {call dose.crypto_pkg.get_Batch_Report(?,?,?,?,?,?,?,?,?,?)} Dean Murray --=_alternative 003F6901852575A0_= Content-Type: text/html; charset="US-ASCII"
Note: If this is the second time this email appears, I sent this before I registered so I am not sure if the first one got through.
Hi

I am using IBATIS 2.3 in a Spring Framework and the stored procedure is in a Oracle 10g database.  The error I get is Retrieving LOBs from a CallableStatement is not supported;   .  Is there a way to retrieve BLOBS using a callable statement. I was able to do it using a select but now I need to make this stored procedure call.

<parameterMap class="BatchReport" id="batchReportMap">
                <parameter property="reportId" jdbcType="INTEGER" javaType="java.math.BigDecimal" mode="INOUT"/>
                <parameter property="creationDate" jdbcType="DATE" javaType="java.util.Date" mode="OUT" />
                <parameter property="reportType" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"/>
                <parameter property="reportNm" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"/>
                <parameter property="report" jdbcType="BLOB" javaType="[B"  mode="OUT"/>
                <parameter property="sendInd" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"/>
                <parameter property="batchIdCd" jdbcType="INTEGER" javaType="java.math.BigDecimal" mode="OUT"/>
                <parameter property="processorId" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"/>
                <parameter property="modifiedBy" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"/>
                <parameter property="modifiedTime" jdbcType="DATE" javaType="java.util.Date" mode="OUT"/>
 
  </parameterMap>
 
   <procedure id="getBatchReport" parameterMap="batchReportMap" resultClass="BatchReport" >
   {call dose.crypto_pkg.get_Batch_Report(?,?,?,?,?,?,?,?,?,?)}
   </procedure>


Dean Murray
 --=_alternative 003F6901852575A0_=--