INSERT INTO ... getNextID

[nmicoud]

Hi everyone,

I've added a T_ table to store records generated by process (using sql and java to fill it) in order to show them in reports (Jasper or standard).
This table has a lot of columns (including mandatory ones and ID).

A report take a very long time to generate and i modify process in order to remove java and only doing it via sql. Performance is greater so i would like to go on this way.
But i cannot manage to fill ID column. My sql statement looks like "INSERT INTO T_Nico_Report (...) SELECT ... ".

I'd prefer to keep working on this table. And my question is, how can i get and update sequence for this table within a sql statement ? (working on oracle)
I've tried to call nextID and AD_Sequence_Next but never managed to succeed.

Any ideas or exemple ?

Thanks,

Nicolas

[globalqss]

Nicolas, on oracle there is a function nextIDFunc

Regards,

Carlos Ruiz

[nmicoud]

Thanks Carlos for the tip ; in the meantime, i've tried using oracle sequences and it seems working fine, even if multiple users launch reports simultaneously.
The nexiID function does the same ?
Thanks,

Nicolas