OraFAQ Forum: Forms » Could not reserve record (2 tries), keep trying?

Home » Developer & Programmer » Forms » Could not reserve record (2 tries), keep trying? (oracle db10g and developer 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Could not reserve record (2 tries), keep trying? [message #530147]

Sat, 05 November 2011 00:57

sairayaqoob82
Messages: 9
Registered: November 2011
Location: Pakistan

Junior Member

Hello
I administer a database oracle 10g for a small company .
the we mostly work in oracle forms 6i
and after 2 3 days a message springs up "Could not reserve record (2 tries), keep trying?" when a user tries to save a record .
Is there any decent solution to this problem other than restarting the Db server all over again .??? help will be appreciated .

Report message to a moderator

Re: Could not reserve record (2 tries), keep trying? [message #530152 is a reply to message #530147]

Sat, 05 November 2011 03:11

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It seems that someone locked a record; until he/she releases it by issuing either a COMMIT or ROLLBACK, the record will remain locked.

As it is a small company, go talk to employees and explain them that they shouldn't leave a form open and go out for a break, but exit to menu (at least).

Report message to a moderator