Creating additional software objects in the geo database

This item is required only for geo databases that are intended to be recorded to by external clients that are not ArcGIS products. If the geo database is provided to external clients only for reading, you can skip this item.

The field OBJECTID, pre-allocated for all tables with spatial data in the geo database, it is intended to maintain a unique record identifier. This field, depending on the initial settings of the geo database, can be auto-critical (filled automatically for new entries). But, as a rule, the application ArcGIS is responsible for generating new values in this field, that is, there is no automatic filling. When creating new records in spatial data tables by external clients that are not applications of the family ArcGIS, it is necessary to implement the receipt of a new value for the field OBJECTID.

To obtain a new value for the field OBJECTID, both external clients and applications ArcGIS were executed according to the same rules, triggers are created in the database Oracle on each spatial data table registered in the geo database. Trigger function – to generate a new value for the field OBJECTID, if this value was not specified when adding a new record.

When creating a new value for the field OBJECTID in triggers, the function NEXT_ROWID of the geo database is used from the package GDB_UTIL.

To create the necessary triggers, it is necessary to connect the database Oracle in which the geo database is deployed, on behalf of the user SDE and to execute the script SQL make_triggers_for_objectid.sql (for example, using the application Oracle SQL Developer).