Create Unique ObjectId in Oracle out of different shapes, daily.

You could use an sqlcreator to get the max ObjectID in the existing table and then add this figure to the count attribute to gain the ObjectID

This works for me in PostGIS.

Unfortunately, Oracle does not support the implicit creation of sequences, like PostgreSQL does. Something like it (IDENTITY column) was introduced in Oracle 12c, but as far as I know that syntax it isn't supported by FME.

Thank you for your fast reaction. Do you have written this down once?

My SQl is not very good. So if you have an example, I can adapt this to my case.

I've tried, but for Oracle the above will not work. I'm going to try the SQL-script.

Thank you!

select Max(ObjectID) as LastId from etc.

Then use counter and set start from = LastID

Within an sqlcreator something like the following

select max(ObjectID) as maxObjectID from table1

This will return a single record with an attribute called maxObjectID which you can use.

You could then join this with your other records and using an attributecreator set ObjectID to equal count + maxObjectID for example

It works. Thank you

Just a small detail: Since Oracle is upper case by default, the attribute you need to expose will be called MAXOBJECTID

But if you expose attributes using "populate from SQL query" FME will helpfully sort this out for you, and also confirm you've got your sql right. :-)