ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jan Vissers <Jan_Viss...@planet.nl>
Subject Possible to write (Oracle) insert into ... using returning clause?
Date Tue, 04 Jan 2005 09:17:27 GMT
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/>


Mime
View raw message