hi,
I have 2 tables as master detail realtionship
If I do a insert in the child table from one user session and without doing the commit or rollback if I try to do an update on master table from different user session then I get the lock until I do the commit or rollback in first user session where I was inserting a record in child table.
The record I am trying to update in the master table all together a different record .
Can anyone suggest the better solution for this
Thanks,