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
select seq_one f
Has anyone got this to work for them. I find out that the second selectKey does not not work too well
select seq_one from dual
select seq_two from dual
insert into TABLE_NAME (column1, column2, column3) values (#col1#, #col2#, #col3#)