Re: Locking Problem

Thanks for this suggestion - I checked it out but it seems to be OK. Foreign keys in the relevant tables appear to be covered by indexes. In one case where the FK was a component of the PK of the child, I tested the effect of inserting to the child (without commit), then updating the parent table - the update worked as long as the row in the parent table corresponding to the inserted child row was not updated.

Any more ideas anyone?

Marco Blanco wrote in message <7bgcov$rbh$1_at_diana.bcn.ttd.net>...
>may be, if you have foreing keys in the table, oracle recomends index to
put
>the lock in index rather than row.
>Extrange thing.... the explanation is in oracle server application
>developer,s guide chapter 6
>
>
>
Received on Tue Mar 02 1999 - 19:10:00 CST