| LOCKING PROBLEM IN DEVELOPER 2000 APPLICATION [message #82580] |
Tue, 10 June 2003 22:29  |
Padmalaya Nanda
Messages: 7
Registered: June 2003
|
Junior Member |
|
|
I've an application developed using developer 2000. The appl. needs to be accessed
by multiple users, as there is a post-query trigger on one block(having multiple records)
, which assigns some value to one of the items of the block, so the records are locked.
So whne the second user accesses the application, he gets
"FRM-40501:Oracle error:Unable to reserve record for update or delete" error for
each record of the block. How can I make the block read only when the second user
accesses the application, which trigger i should use, if the trigger is on-lock,
then what should I write in that trigger. Pls. reply asap, it's very very urgent.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
