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

[Bud]

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 solution]

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-...

The SP is called i##_get-ids

[Bud]

Thanks.

Also: Editing nonversioned geodatabase data in Oracle using SQL

INSERT INTO eng2.streams (OBJECTID,NAME,SHAPE) 
 VALUES (
  sde.gdb_util.next_rowid('ENG2', 'STREAMS'), 
  'TRANQUIL', 
  sde.ST_GEOMETRY('linestring (750 150, 750 750)', 4326) 
 );