RE: SQL Next Sequence

Curious as to why you want to know the next sequence number.

You don't need to provide the value to add a row to your table- that's kind
of the point of allowing the system to generate the value.

If you want to know the identity value assigned to a row after it has been
inserted (so you can use it as a foreign key for other tables that refer to
this row), something like this should do the trick.

SELECT id INTO :newid
FROM FINAL TABLE
( INSERT INTO yourtable ...)