Dear All,
I am stuck in the following scenario:
In a dual processor machine, I am running 5 threads.
each of the threads is calling a particular stored procedure to insert a row in the table.
the insertion takes place in a transaction and i have set the transaction level to serializable.
However it seems that the insertion is not taking place properly because of the threads.
isnt the isolation mainiatined in case of threads?
what is it that I can possibly do to provide isolation amongst threads
Please tell, in case I should provide more info in regard to this scenario?
Thank You in advance
Regards
Surabhi Ahuja