Set of DML in One Logical Transaction

From: N J Neog <njneog_at_oil.asm.nic.in>
Date: Wed, 06 Jun 2001 21:42:17 -0700
Message-ID: <F001.0031F981.20010606203023@fatcity.com>

Hi,

Kindly help me solving the following problem.

  I have 2 table as follows,

TAB1

1. CUST_ID Number(6), --- PK
2. Name   Varchar2(50),
3. curr_Amt        Number(12,2)

TAB2.
1. Tran_id        Number(3),
2. Tran_dt        Date,
4. CUST_ID    NUmber(6) --- FK to TAB1
5. AMT            Number(10,2),

If there is any "Insert or Update" is going on Table Tab2, No other session should even
 "See" the corresponding record(Matching CUST_ID) from TAB1 i,e no user should be able to fire Select, Update record from TAB1.

Once the "Insert or Update" in Tab2 is successful , one more UPDATE will be fired to
TAB1 (cur_amt) and that will Complete the transaction.

How do I achieve it ?

Thanks in Advance.

Naba

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: N J Neog
  INET: njneog_at_oil.asm.nic.in

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 Wed Jun 06 2001 - 23:42:17 CDT