Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How Can I Avoid Table Locks that normally shows data in query mode.

usman_noshahiFeb 6 2018 — edited Feb 8 2018

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.

This post has been answered by Zlatko Sirotic on Feb 6 2018
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 8 2018
Added on Feb 6 2018
2 comments
3,013 views