Function to get next OBJECTID when inserting data into Oracle FC using SQL

Question

Oracle:

I remember there being a SDE function for getting the next OBJECTID -- when inserting data into an Oracle FC using SQL. But unfortunately, I can't remember the function's name. And I can't find that section in the Esri documentation.

Does anyone remember what it's called or where I can find info in the docs?

(I'm aware that there are risks/things to consider when editing FC data using SQL. I'm just doing some testing in some fake data.)

Thanks.

ryanuthoff · Accepted Answer

I believe this is what you're looking for. https://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/workflow-using-sql-with-existing-feature-classes.htm

The SP is called i##_get-ids