topic Re: Function to get next OBJECTID when inserting data into Oracle FC using SQL in ArcGIS Enterprise Questions

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

Bud — Thu, 06 Apr 2023 14:35:13 GMT

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.

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

RyanUthoff — Thu, 06 Apr 2023 14:47:38 GMT

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

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

Bud — Thu, 06 Apr 2023 15:02:01 GMT

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) 
 );