As I read through the underlying requirement of having a sequence generator, can you use a temporary variable of type Integer in your process flow that defines the sequence. With this, you will need not fetch the max (id).
If, however, your table is getting row data from other processes as well, then you lose track of sequence, in which case you may want to get the max(id)
You either need to use ANSI SQL or the premium Oracle connector. ANSI would be my choice, changing the end of the query to "LIMIT 1"
Scott S Nelson
If I understood your requirements correctly, you can create a view with a single field in Oracle and reference it to get Max(Id) before assigning a next one to a new row.
Something like this:
CREATE VIEW max_id_from_testtable AS
SELECT max(id) maxId
Thus you even won't need to use a guery, just select the field from the Content.