Dirty records on Oracle client-server database 
Author Message
 Dirty records on Oracle client-server database

Hi there.

Has anyone ever had problems with updating single records in
a Oracle table, with a error like:
'Couldn't perform edit because another user changed the record'
(And of course there no other users even on the database).

The problem arises whether I use a DBGid, perform a batch
move, post a change manually or edit the table using the
Database Desktop.
I have tried all three posible settings for the database's
TransIsolation property.




Tue, 19 Oct 1999 03:00:00 GMT
 Dirty records on Oracle client-server database

Quote:

> Hi there.

> Has anyone ever had problems with updating single records in
> a Oracle table, with a error like:
> 'Couldn't perform edit because another user changed the record'
> (And of course there no other users even on the database).

One I can think of is that of a trigger in someone else's schema after some
operation on the dataset. Oracle will do that if I access a <user>.<table>
logged in as myself, update it, which fires <user>.<trigger> etc... '
'...another user...' is just the owner of the trigger in this case.

Maybe you're hitting the same kind of problem?

Jasper



Tue, 19 Oct 1999 03:00:00 GMT
 Dirty records on Oracle client-server database

Quote:

> Hi there.

> Has anyone ever had problems with updating single records in
> a Oracle table, with a error like:
> 'Couldn't perform edit because another user changed the record'
> (And of course there no other users even on the database).

> The problem arises whether I use a DBGid, perform a batch
> move, post a change manually or edit the table using the
> Database Desktop.
> I have tried all three posible settings for the database's
> TransIsolation property.



There are multiple 'transisolation' levels you can use to access your
data.  look transisolation up in the Delphi Help.

Basically, you can lock out the post if ...
  - any data in the row was changed by another user
  - any of the fields YOU changed were also changed by another user
  - any Key field was changed by another user...

This is pretty well explained in the help file.

--
--------------------------------------------
In theory, theory and practice are the same.
In practice, they are not.
--------------------------------------------
Bryan Valencia
Software Services - Making Windows Scream
WWW   : www.invsn.com/softserv/

--------------------------------------------



Tue, 19 Oct 1999 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. US-MD-Baltimore, Database Programmer, Client Server, SQL based relational database, Mac and PC Clients

2. US-MD-Baltimore, Database Programmer, Client Server, SQL based relational database, Mac and PC Clients

3. MD-Oracle Database Administrator- $60-75K- Oracle DB2 IMS Client/Server

4. 18517-TX-DALLAS-ORACLE-Mainframe-Client/Server-UNIX-Oracle Database Administrator

5. Information passing between the Oracle Client and an Oracle Database server

6. 18142-TX-DALLAS-ORACLE-Mainframe-Client/Server-UNIX-Oracle Database Administrator

7. 18142-TX-DALLAS-ORACLE-Mainframe-Client/Server-UNIX-Oracle Database Administrator

8. Oracle Client-Server Technology - when there are 2 local servers and 1 remote client

9. Sybase 11 Dirty Reads from a C++ client

10. Dirty buffers update / record locking

11. How to get Dirty Records?

12. Problem connecting an oracle client behind Wingate proxy server to an oracle server not behind proxy


 
Powered by phpBB® Forum Software