| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: Notification when something changes in the DB
Not so weird, PeopleSoft does things in a similar manner. When a panel in PeopleTools is queried a copy of the data is sent to the screen for modification. A second in retained in memory as the original version. When the user presses the 'save' button a third copy is retrieved from the database and compared to the second copy. If they match the modified data is saved to the database which was queried the second time 'for update of' so that a row level lock is established at that time. Now if the data had been modified this irratating message pop-up appears telling you that the underlying data has been modified & you have to start all over again.
In general letting Oracle handle the locking of data is the best way to go, so either acquire a 'for update' lock when you pull the data or do the double query if you really need it.
Dick Goulet
---------------------- Reply Separator ----------------------Author: John Lewis <jlewis_at_punchnetworks.com> Date: 9/4/01 1:51 PM
>For whatever reasons this solutions was found to be not sound by a 3rd
>party "consulting" company which reccommended "Oracle native
technology"
>to perform this check.
Hmm... a trigger seem native to me. Perhaps they meant auditing.
-----Original Message-----
[mailto:Val_Gamerman/Victoria_Financial.VICTORIA_FINANCIAL_at_lnn.com]
Sent: Tuesday, September 04, 2001 2:33 PM
To: Multiple recipients of list ORACLE-L
Hello fellow DBAs',
I have a weird question that I was asked. My first reaction was to
answer:
"There is no such thing", however I was talked into posting this
question
here :-)
For whatever reasons this solutions was found to be not sound by a 3rd
party "consulting" company which reccommended "Oracle native technology"
to perform this check. This company is now unreachable and "management"
is
requesting to change the application to follow this "review".
Management explanation of how it needs to be done is based on what ADO
would do where if you perform an optimistoc lock and then later on try
to
update an already updated record it would tell you about this upfront.,
or
you would be able to check upfront WITHOUT requiring the DB. I am not
familiar with ADO, that much so I can not comment on it.
Can somebody tell me if they can think of way to achieve this?
I know it sounds rather weird request -- it is.
Thanks in advance for any thoughts on this,
Val Gamerman.
Oracle DBA
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Val_Gamerman/Victoria_Financial.VICTORIA_FINANCIAL_at_lnn.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: jlewis_at_punchnetworks.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet_at_vicr.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Sep 04 2001 - 22:07:07 CDT
 |
 |