Multiple selectKey in Oracle

[Folashade Adeyosoye]

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>