FYI:
https://community.esri.com/t5/geodatabase-questions/sql-trigger-not-executing-on-initial-insert/td-p...
ArcGIS seems to execute two db operations to create a spatial record:
- Create the geometry and OBJECTID.
- Update the record with the rest of the attribute values.
It looks like one operation to the front-end user, but in the background it is actually two. The solution is to put triggers for attribute values in an AFTER UPDATE trigger.
| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Database Certified Professional | "About: In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 33 years, my passion for Spatial Databases and GIS data has become a central part of my career.." | “ The mountains are calling and I must go.” – John Muir |
