Re: Oracle Lock problem ! i really need help !

From: <anonymous_at_nowehere.net>
Date: 1996/11/11
Message-ID: <567gia$b48_at_nike.volvo.se>#1/1


In article <328495D3.4469_at_easynet.fr>,

   Guillaume MAISON <maison_at_easynet.fr> wrote:
>Hi all !
>
>Before, i have to say that i'm quite new to Oracle...
>i'm using Oracle 7.0.16.6.5 on a Netware (3.12) server.
>
>Here's my problem :
>
>i have two tables A & B.
>B references A by a foreign key.
>
>On the first station, when i insert a row into table B, just before the
>insert, i run a stored procedure which insert a row in table A.
>but the commit isn't made immediatly. i have to do several things before
>the commit (or rollback) which can take a long time.
>
>On the second station, i try to do the same thing (i mean inserting a
>row in table B and just before this insert, running the stored procedure
>which insert into table A), i can't launch the stored procedure.
>On this second station, eveerything is stopped, waiting for the first
>station to commit or rollback.
>
>after few searches, i've found that inserting into table A on the first
>station locks the entire table B, and so i can't do anything with table
>B from another station.
>
>coud anyone help me ?!
>
>i need a really urgent answer !
>
>e-mail me the answer (or if you need more details)at : maison_at_easynet.fr
>
>Thanks in advance !
>
>Guillaume
  Received on Mon Nov 11 1996 - 00:00:00 CET

Original text of this message