You can use autonomous transaction to achieve this.

But when parent and child relationship exists, I would not do what you are trying to do. Basically, you have to design a system that works in all conditions. You may have to go back your drawing board.

Tamil