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>
