RE: Design question
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <ChrisStephens@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 22 Oct 2004 14:22:33 +0200
Chris,
did you look at the DBMS_LOCK package? that might provide the functionality
you need ...
Kind regards,
Lex.
-------------------------------
visit http://www.naturaljoin.nl
-------------------------------
skype me <callto://lexdehaan>
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Stephens, Chris
Sent: Friday, October 22, 2004 13:09
To: oracle-l@xxxxxxxxxxxxx
Subject: Design question
=20
I've just been asked to attend a meeting this morning to resolve the
following issue:
Data resides in Oracle.
.NET application pulls relevant data out into an xml file, brings it
back to the client which has a sql-server database locally. The data
may or may not be updated. If it is, the updates are sent back to
Oracle.
Meanwhile there is a complete separate application (not sure what it is
implemented in) that needs to be prevented from modifying the data which
the .NET application users are currently using. ....the question is how
exactly to do this.
....my first impression was to somehow make use of the 'select..for
update' and push pl/sql processing but since the data is shipped off via
an xml file and the system is already developed, I don't think that's
possible. ...the only other option that I can think of (and the one
they were already thinking of) is to have a column that indicates
whether a rows is locked by some .net user...assuming the data comes
from a single table. If the data resides in multiple tables I think
that best option is to create a 'data_lock' table that holds the keys
from each individual table for the lifetime of the 'transaction'.
Any better/additional ideas?
Not exactly a database centric environment here. :)
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
