Return-Path: 
 <user-java-return-15163-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 38638 invoked from network); 27 Aug 2008 18:21:59 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 27 Aug 2008 18:21:59 -0000
Received: (qmail 70506 invoked by uid 500); 27 Aug 2008 18:21:55 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 70489 invoked by uid 500); 27 Aug 2008 18:21:55 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 70478 invoked by uid 99); 27 Aug 2008 18:21:55 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 27 Aug 2008 11:21:55 -0700
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of larry.meadors@gmail.com
 designates 72.14.220.155 as permitted sender)
Received: from [72.14.220.155] (HELO fg-out-1718.google.com) (72.14.220.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 27 Aug 2008 18:20:57 +0000
Received: by fg-out-1718.google.com with SMTP id d23so29630fga.32
        for <user-java@ibatis.apache.org>;
 Wed, 27 Aug 2008 11:21:09 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:received:received:message-id:date:from:reply-to
         :to:subject:in-reply-to:mime-version:content-type
         :content-transfer-encoding:content-disposition:references;
        bh=Qr/v3/qUFMqiWN7ApLZm7q6o3AGRCnkswvds5k6uWfE=;
        b=irdELmUAadtYHc8MOSQ4jyxgTwhxAbcQlvnk9wwENV2tKY+akioitbvrKshdreKCHz
         cwN+xg0XZFZgOVcTda7AZv+I7Ahc1b1kEaiH7Zfp+wFSYatuebJ/Ftw3JnhiuzpJ+tgk
         TivbGk8YpnFX/PGe4QHAY+fY+Y6il2jFTRUa0=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:reply-to:to:subject:in-reply-to:mime-version
         :content-type:content-transfer-encoding:content-disposition
         :references;
        b=MgQuOX73Ei8Iq3WvnGhQvaB3nEWkOOcGSLQNgmgg4UpFfExB9yQc1FThAizIBeTyVj
         /8AtPmCpgCUWR8nZU8+O9Yy6ir4x1g+B3WevgMQFwdS8dkVhmLOiYspz8d3hW5QjSqKX
         n9exh5NJCqaqjm2V/1xV2XpIQDMQTEJflw7yU=
Received: by 10.181.25.10 with SMTP id c10mr272099bkj.99.1219861269148;
        Wed, 27 Aug 2008 11:21:09 -0700 (PDT)
Received: by 10.181.1.9 with HTTP; Wed, 27 Aug 2008 11:21:09 -0700 (PDT)
Message-ID: <a10a823c0808271121t72654b95vd6e970ff72c1a45d@mail.gmail.com>
Date: Wed, 27 Aug 2008 12:21:09 -0600
From: "Larry Meadors" <larry.meadors@gmail.com>
Reply-To: larry.meadors@gmail.com
To: user-java@ibatis.apache.org
Subject: Re: How to execute a SQLstatement and followed by a StoredProcedure.
In-Reply-To: <631123700808271117g7bb97a8amd29991590668b7d3@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <631123700808271117g7bb97a8amd29991590668b7d3@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org

Why not just put the insert/sp call in a single stored procedure?

If not that, I think you'll need to just call the 2 mapped statements,
or find a way to do it with sql (like an anon pl/sql block in oracle).

Larry


On Wed, Aug 27, 2008 at 12:17 PM, bala r <balar4u@gmail.com> wrote:
> Hi,
>
> I need to execute Select statement and followed by a Stored Procedure.
> Stored Procedure parameter is from the SQL Selectstatement result.
>
> 1. Select x into p_x from temp_table
>  2. call stored_procedure(p_x)
>
> Both should be same sqlMap id .
>
> I tried using <statement> but didnt work.
>
> Is there a way shall i execute both in one sqlMap id?
>