Oracle form is not updatable after using WHEN-VALIDATE-ITEM trigger

1.4k Views Asked by At

I have developed an Oracle form which is Master Details form. It does not allow insertion of new records but you can update records on the form. When I added a WHEN-VALIDATE-ITEM trigger on an item, the form disables updates. I am not able to change any value in the form and save it.

1

There are 1 best solutions below

2
On

WHEN-VALIDATE-ITEM trigger is bad choice to avoid inserts or updates on block. Set Insert-Allowed to False and Update-Allowed to True in block properties.