REPOST: Question about locking a record.

From: C Chang <cschang_at_maxinter.net>
Date: Sun, 30 Dec 2001 01:35:56 -0500
Message-ID: <2$--$$_--%$_$%%_-$@news.noc.cabal.int>

I have an update procedure needed to lock the reocrd for a certain of period. Can Oracle DBMS or in PL/SQL do this? The problem comes from a web page that transfers its content to a new page waiting for further process. When the record is transfered, I would like it been locked for a certain of time, so that the same record can not be updated during the transfered and processed. Since I do not know how long the record will be finished the process ( it may not as user walks away ), so I need the reocrd only be locked for a ceratin of time. Thanks in advance.

C Chang

WAS CANCELLED BY =======: Message-ID: <cancel.3C2EB5CC.6CDD_at_maxinter.net> Control: cancel <3C2EB5CC.6CDD_at_maxinter.net> Subject: cmsg cancel <3C2EB5CC.6CDD_at_maxinter.net> From: C Chang <cschang_at_maxinter.net> Newsgroups: comp.databases.oracle.misc X-No-Archive: yes Lines: 2 NNTP-Posting-Host: wonenara.ozemail.com.au X-Trace: ozemail.com.au 1009694817 203.108.164.177 (Sun, 30 Dec 2001 17:46:57 EST) NNTP-Posting-Date: Sun, 30 Dec 2001 17:46:57 EST Organization: OzEmail Ltd, Australia Distribution: world Date: Sun, 30 Dec 2001 04:59:53 GMT Path: news.sol.net!spool0-nwblwi.newsops.execpc.com!newsfeeds.sol.net!newspump.sol.net!news.maxwell.syr.edu!news1.optus.net.au!optus!yorrell.saard.net!duster.adelaide.on.net!newsfeed.ozemail.com.au!ozemail.com.au!not-for-mail

This message was cancelled from within Mozilla. Received on Sun Dec 30 2001 - 00:35:56 CST