QUOTE (Ranjana @ Jul 29 2008, 03:58 PM)
I would like to know if a rollback is possible in a multi-session table insert.
Consider there are 3 separate sessions.
Each session performs an insert into different tables.
If an error occurs in 3rd session, is it possible to rollback all the 3 inserts?
Could you please help me in this?
To make it more clear I would explain the entire scenario.
There is a front end application with 3 tabs.
For each tab a separate screen opens up.
All screens contain fund information. eg: Screen1- Fund Overview;Screen2 - Financial; Screen3- Ratings.
The details entered in the front end by the user would be in xml format.
This needs to be inserted into respective Data base tables.There would be separate xml for each screen.
I mentioned it as multi-session as there are individual Web-services call to Data Base procedures for each tab.
If an error occurs in Screen 3 insert, then I need to rollback the records inserted from the first 2 screens.Else the information in the tables related to the fund would be incomplete.
I hope the information provided is clear.