REPLACE GIS MaxObjectID p_owner VARCHAR2 p_tablename VARCHAR2 NUMBER max_objectid NUMBER regid NUMBER vc2SqlStr VARCHAR2 tr REGISTRATION_ID regid SDE TABLE_REGISTRY tr tr OWNER p_owner tr TABLE_NAME p_tablename EXCEPTION OTHERS regid : vc2SqlStr : p_owner p_tablename p_owner regid IMMEDIATE vc2SqlStr max_objectid EXCEPTION OTHERS max_objectid : max_objectid MaxObjectID
BEFOREWS A658 max_objectid WS A658 objectid : max_objectid : GIS MaxObjectID max_objectid :new eid :new objectid max_objectid HYDRANT_EID_SEQ NEXTVAL :NEW EID DUAL
I'm not familiar with SDE in Oracle so I can't comment specifically on that.
However, I can tell you that an OBJECTID is not guaranteed to be larger than the previously added record. If multiple processes are writing to the table, one process could reserve a slice of OBJECTIDs for itself. Then, if a second process starts adding records before the first one is done, the lower OBJECTIDs of the first process will be intermixed with the higher OBJECTIDs of the second process.