ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sven Boden <list...@pandora.be>
Subject Re: Multiple selectKey in Oracle
Date Tue, 21 Mar 2006 18:53:11 GMT
Because there can only be 1 return value. You can have multiple keys 
generated in Oracle per row, but you can only return one.

Sven

Folashade Adeyosoye wrote:

>Has anyone got this to work for them. I find out that the second selectKey
>does not not work too well
>
>
><insert id="taskName" parameterClass="objectName">
>    <selectKey keyProperty="col1">
>          select seq_one from dual
>    </selectKey>
>    <selectKey keyProperty="col2">
>          select seq_two from dual
>    </selectKey>
>
>    insert into TABLE_NAME (column1, column2, column3) values (#col1#,
>#col2#, #col3#)
></insert>
>
>  
>


Mime
View raw message