| unlock record [message #286455] |
Fri, 07 December 2007 08:32  |
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 #286634 is a reply to message #286517] |
Sun, 09 December 2007 03:29  |
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 #288996 is a reply to message #288891] |
Wed, 19 December 2007 04:15 |
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 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
