Oracle forms unable to reserve record for update or delete

When we try to input any data in this application using an Oracle Form then we get the following error "FRM ORA ORACLE error: unable to reserve record for update or delete" once this error appears there is an another error ORA - and all connections will be lost , This error does NOT occur when we login as the database user that owns the tables and editioning views but for every other database user we get this error , this error is only happening to some selected view and all others views are working fine.

We have done below checking and found no issues in it 1 Tried to update view from backend and it works fine. Please let me know if you face similar issue or have any suggestions regarding this. I have minimal experience with Forms, so don't know what's the issue is. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore Design New to good database design? Check out Chris Saxon's full fundamentals class. Collectives on Stack Overflow. Learn more. FRM unable to reserve record to update Ask Question. Asked 4 years, 10 months ago. Active 22 days ago. Viewed 7k times. Mario R. Ayoub Mario R. Ayoub 3 1 1 silver badge 7 7 bronze badges. Can you add some sample data here to make your question more concrete?

You may just be looking for a simple update statement, or possibly something more. I deleted mysql tag — Mario R. Show 1 more comment. Active Oldest Votes. It worked for me for multi-sessioned workaround.

Add a comment. Sign up or log in Sign up using Google. Sign up using Facebook.