ORA-01445 with instead of trigger

[lavernhe]

We used DOA v 3.4.6.1. We've tried to update a dataset based on a view with an

 

[Marco Kalter]

You should probably use the OnApplyRecord event to override the standard lock action, and lock the record from the main table instead of the view. All other actions do not need to be overruled.

------------------
Marco Kalter
Allround Automations

 

[lavernhe]

When a uniquefield is specified, DOA use it for performing insert, update and delete record.

So can you explain why DOA use the rowid column (in the where clause of the view) for checking and locking the record ?

Thanks for your help

Best Regards

 

[Marco Kalter]

Actually, the UniqueFields are only used to determine the rowid after an insert. For all other applicable operations the rowid is used.

------------------
Marco Kalter
Allround Automations