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?

Improve this question
3
  • When a DELETE is requested on the view (not the feature class).
    – Vince
    Commented Aug 23, 2020 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?
    – User1974
    Commented Aug 23, 2020 at 13:33
  • 1
    Versioned views are for use from SQL, not ArcObjects. The documentation describes their use case.
    – Vince
    Commented Aug 23, 2020 at 14:24

1 Answer 1

Reset to default
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.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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