Multiple tables and commit [message #373264] |
Fri, 06 April 2001 14:25 |
Mike
Messages: 417 Registered: September 1998
|
Senior Member |
|
|
I have a problem that I hope someone may be able to assist me with:
In Program1, I do
insert into TABLE_A;
update TABLE_B;
commit;
In Program2 milliseconds later, there are rare cases where it appears that it see the new row in TABLE_A but not the update to TABLE_B which causes Program2 to fail.
There are no other programs that would be accessing that row in TABLE_B.
Can I safely dismiss the theory that Oracle is to blame by committing Table_A before Table_B??
Is changing the code to do the update first a waste of time and effort?
Any suggestions as to why this might happen appreciated!!
|
|
|