Oracle® Objects for OLE C++ Class Library Developer's Guide 10g Release 2 (10.2) Part Number B14308-01 |
|
One of the defining features of client-server computing is that many clients may be accessing the server simultaneously. This feature means that several clients may access the same table or record simultaneously. In Oracle this issue is generally resolved using locks. Locks allow one client to restrict other client's use of a table or record. Locks are placed temporarily on database entities to prevent confusion and data corruption.
When you use Oracle Objects for OLE, locks are not placed on data until an ODynaset executes the StartEdit method. The StartEdit method attempts to obtain a lock (using "SELECT ... FOR UPDATE") on the current record of the dynaset. This is done as late as possible to minimize the time that locks are placed on the records. The StartEdit method can fail for several reasons: