I am using Database 12c with Oracle Forms 12.2.1.3.0 (Production)
I have one module that loads or shows twelve month history of Student and end use can update the any record as per required.
But I have noticed that, before posting of committing, The underlying table becomes under lock and at the same time if there any insert in the same table, entire the process stucks.
I am trying to use View but form is not allowing to update the view in case I want to use Instead of triggers.
Please guide me, how can I hold the update at once without facing any locks because this table is used for updates and insert from other modules too.
Thanks.