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