0

Oracle 18c/10.7.1 geodatabase:

When an FC is registered as versioned (with option to move edits to base), several triggers get automatically created:

  • V000001_DELETE
  • V000001_INSERT
  • V000001_UPDATE

When I look at the _DELETE trigger, I see that it belongs to the versioned view:

INSTEAD OF DELETE
ON MAXIMO.TEST_FC_EVW  --<<--- versioned view

If I delete a feature from the feature class while using the default version, the trigger does not get called.

Question:

Under what circumstances would the _DELETE trigger get called?

3
  • When a DELETE is requested on the view (not the feature class). – Vince Aug 23 '20 at 11:53
  • @Vince I wasn't aware that users could edit/delete data through views in ArcObjects applications. Are the deletes on the versioned views done by users, or are they done by a backend process? – User1973 Aug 23 '20 at 13:33
  • 1
    Versioned views are for use from SQL, not ArcObjects. The documentation describes their use case. – Vince Aug 23 '20 at 14:24
1

The delete trigger would get called when deletion of the feature is done from a child version. The deleted row would be stored in the delta D table created upon registering the FC as versioned for the feature class.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.