Return-Path: <Jan_Vissers@planet.nl>
Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Delivered-To: mailing list ibatis-user-java@incubator.apache.org
Delivered-To: moderator for ibatis-user-java@incubator.apache.org
Received: (qmail 18564 invoked by uid 99); 4 Jan 2005 09:17:40 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from smtp14.wxs.nl (HELO smtp14.wxs.nl) (195.121.6.28)
  by apache.org (qpsmtpd/0.28) with ESMTP; Tue, 04 Jan 2005 01:17:36 -0800
Received: from [145.53.56.90] (ip9135385a.speed.planet.nl [145.53.56.90])
 by smtp14.wxs.nl (iPlanet Messaging Server 5.2 Patch 2 (built Jul 14 2004))
 with ESMTP id <0I9S008D6CH5JB@smtp14.wxs.nl> for
 ibatis-user-java@incubator.apache.org; Tue, 04 Jan 2005 10:17:29 +0100 (CET)
Date: Tue, 04 Jan 2005 10:17:27 +0100
From: Jan Vissers <Jan_Vissers@planet.nl>
Subject: Possible to write (Oracle) insert into ... using returning clause?
To: ibatis-user-java@incubator.apache.org
Message-id: <41DA5F27.7090105@planet.nl>
MIME-version: 1.0
Content-type: text/plain; charset=ISO-8859-1; format=flowed
Content-transfer-encoding: 7BIT
X-Accept-Language: en-us, en
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Virus-Checked: Checked

Using ibatis sqlmap, is there someway to have a <insert ...> where the 
SQL is something like:

insert into TABL(COL1,COL2) values #col1#, #col2#)
returning COL1,COL2 into #col1#, #col2#

There might some (Oracle) trigger code going on underneath (making COL1 
uppercase for example) and I want to use the "returning .. into .." clause.

Thx,
Jan.

-- 
Get Firefox! <http://www.spreadfirefox.com/?q=affiliates&id=0&t=55> 
 And  	Get Thunderbird <http://www.mozilla.org/products/thunderbird/>