TransWikia.com

Under what circumstances would the _DELETE trigger get called? (_EVW)

Geographic Information Systems Asked on December 13, 2020

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?

One Answer

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.

Answered by S_K on December 13, 2020

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP