Home » Developer & Programmer » Forms » unlock record
unlock record [message #286455] Fri, 07 December 2007 08:32 Go to next message
Hine
Messages: 16
Registered: October 2006
Junior Member
I'm useing the Oracle Forms v9i
In case that mistake in programms occurs, samo records can stay locked
I can unlock records with the kill session.

Can still some otherwise to unlock record??

Regards!

Hine
Re: unlock record [message #286517 is a reply to message #286455] Fri, 07 December 2007 15:21 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, killing a session is the only way to release locked records.
Re: unlock record [message #286634 is a reply to message #286517] Sun, 09 December 2007 03:29 Go to previous messageGo to next message
Hine
Messages: 16
Registered: October 2006
Junior Member
Yes, but in SQL Plus I can use command
SQL> select saddr,said,serial#,username,status from v$session;

How can I use the same command in Oracle Forms v9i procedure!

Regards!

Hine
Re: unlock record [message #288891 is a reply to message #286634] Wed, 19 December 2007 00:36 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: unlock record [message #288996 is a reply to message #288891] Wed, 19 December 2007 04:15 Go to previous messageGo to next message
Hine
Messages: 16
Registered: October 2006
Junior Member
No, because for access to data in table V$SESSION demands additional authorised
I need that, in case that mistake in programms occurs, samo records can stay locked

the user must not activate the same program again, because the old sassion lock records!

Can still some otherwise to unlock record??


Regards!
Re: unlock record [message #289147 is a reply to message #288996] Wed, 19 December 2007 19:38 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
They are getting the message 'record locked by another user' aren't they? If so, get them to ring the help desk and get them to see who has the record locked and if it is by their old session then get the help people to kill the session.

David

Upd typo: 'How' instead of 'who', again.

[Updated on: Fri, 04 January 2008 00:08]

Report message to a moderator

Previous Topic: how to retrieve IP address of machine
Next Topic: Scroll Bar
Goto Forum:
  


Current Time: Fri Dec 09 17:13:50 CST 2016

Total time taken to generate the page: 0.28569 seconds