Return-Path: Delivered-To: apmail-ibatis-dev-archive@www.apache.org Received: (qmail 41522 invoked from network); 8 Jan 2008 15:58:14 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 8 Jan 2008 15:58:14 -0000 Received: (qmail 46801 invoked by uid 500); 8 Jan 2008 15:58:03 -0000 Delivered-To: apmail-ibatis-dev-archive@ibatis.apache.org Received: (qmail 46786 invoked by uid 500); 8 Jan 2008 15:58:03 -0000 Mailing-List: contact dev-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ibatis.apache.org Delivered-To: mailing list dev@ibatis.apache.org Received: (qmail 46775 invoked by uid 99); 8 Jan 2008 15:58:03 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 08 Jan 2008 07:58:03 -0800 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [204.17.31.254] (HELO AMSGEG01.apollogrp.edu) (204.17.31.254) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 08 Jan 2008 15:57:39 +0000 Received: from amsgfe03.apollogrp.edu ([10.17.144.37]) by AMSGEG01.apollogrp.edu with InterScan Message Security Suite; Tue, 08 Jan 2008 08:58:58 -0700 Received: from AMSGEV41.apollogrp.edu ([10.29.167.4]) by amsgfe03.apollogrp.edu with Microsoft SMTPSVC(6.0.3790.1830); Tue, 8 Jan 2008 08:58:57 -0700 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C8520F.6060F641" Subject: How to Call stored procedure with reference to a table as the input param. Date: Tue, 8 Jan 2008 08:58:49 -0700 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: How to Call stored procedure with reference to a table as the input param. Thread-Index: AchRg+QP4yw0hCIBRHSxA3mQzCDMowAi23fw From: "Sundar Sankaranarayanan" To: X-OriginalArrivalTime: 08 Jan 2008 15:58:57.0603 (UTC) FILETIME=[60707930:01C8520F] X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. ------_=_NextPart_001_01C8520F.6060F641 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable i,=20 I have a stored procedure that takes the input parameter as a reference to a table. it uses this to insert.update some values in the table. declare tbl_instance temp_table; -- Cant give the actual name of the table. H=20 begin -- Call the procedure insertStorecProc(tbl_instance =3D> tbl_instance); end; =20 1. Could some one tell me how to map this in my sqlMap xml file. The temp_table contains some 20 fields of which 5 are compulsory. 2. I might need to do bulk updates(10-50 calls). What would be the best approach to do that cos I am dealing with a stored procedure and I am using Spring here. I am using Ibatis in conjunction with Spring 2.5 and am not sure as to how to proceed for this particular case. Any help on this is truly appreciated. =20 Regards Sundar Sankarnarayanan =20 ------_=_NextPart_001_01C8520F.6060F641 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I have a stored = procedure=20 that takes the input parameter as a reference to a table. it uses this = to=20 insert.update some values in the table.

declare

tbl_instance temp_table; -- Cant give the actual name of the=20 table. H

begin

-- Call the=20 procedure

insertStorecProc(tbl_instance =3D> tbl_instance);

end;

1. Could some one tell me how to map this in my = sqlMap xml=20 file. The temp_table contains some 20 fields of which 5 are=20 compulsory.

2. I might need to do bulk updates(10-50 = calls). What would=20 be the best approach to do that cos I am dealing with a stored procedure = and I=20 am using Spring here.

I am using Ibatis in conjunction with Spring = 2.5 and am not=20 sure as to how to proceed for this particular case. Any help on this is = truly=20 appreciated.

Regards

Sundar = Sankarnarayanan

------_=_NextPart_001_01C8520F.6060F641--