Hi All,
I have a piece of code which is executed exactly at the same time in 2 different system. This code actually picks a sequence number and creates a record in another table where this sequence number is the primary key.
Now when this program is run with progress database at the same time on 2 different system (ofcourse need not to say - same DB), Just shows a lock in one system...delays and hence picks next sequence number.
But when i run the same program in oracle database...
** unique constraint (DB.tablename##fiield) violated is displayed.
Is there any way to get rid of this error and still be able to run the program at the same time like it happens in progress.
Please let me know if any one has come accross such situation.
Thank You
Mallika
I have a piece of code which is executed exactly at the same time in 2 different system. This code actually picks a sequence number and creates a record in another table where this sequence number is the primary key.
Now when this program is run with progress database at the same time on 2 different system (ofcourse need not to say - same DB), Just shows a lock in one system...delays and hence picks next sequence number.
But when i run the same program in oracle database...
** unique constraint (DB.tablename##fiield) violated is displayed.
Is there any way to get rid of this error and still be able to run the program at the same time like it happens in progress.
Please let me know if any one has come accross such situation.
Thank You
Mallika
