| reg locking mode in forms [message #132886] |
Tue, 16 August 2005 10:34  |
priyravi
Messages: 41
Registered: July 2005
|
Member |
|
|
hi i have a form where i write a cursor to populate the records of the form the cursor look like this
cursor cur_populate is select * from d6015 order by idsignaling;
but when another user tires 2 access the same form its getting locked......once i exit the first form only the 2nd user is able 2 access it.......i have set the locking mode as delayed and the forms property as serializable but still the problem exists..........this will be a danger in multi user environment.....when i tried 2 look into the locked object table .its mentioned tht oracle has locked the table exclusively.can any one get me solution how to handle this in multi user environment......?????/
|
|
|
|
|
|
|
|
| Re: reg locking mode in forms [message #132948 is a reply to message #132946] |
Tue, 16 August 2005 23:46  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Your post contained "cursor cur_populate is select * from d6015 order by idsignaling". This suggests to me that you are populating a non-database block via a cursor.
You tell me. How many blocks in your form? On what tables are they defined?
David
[Updated on: Tue, 16 August 2005 23:46] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
