Record Locking and Unlocking from ASP.NET using ODP.NET. Possible ?
Hi All,
Is it possible to lock a record using FOR UPDATE in select query and unlock it if no update is done, when the user goes to some other record in the WebForm and if the user edit the data and update the row on click a button. Also, not to show that record for other user's for edit option. Simple Lock record and deny access to other web users. Is it possible to do this from asp.net and odp.net maintaining connection in a Session object, since .net supports disconnected db access.
Yours,
Sankar.B