Re: Multiple selectKey in Oracle

2006-03-21 Thread Sven Boden
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

Multiple selectKey in Oracle

2006-03-21 Thread Folashade Adeyosoye
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#)