Thanks for reply.still i think this will not work for me. let me explain you my requirements. what i want is when i issue commit for second level transaction it should commit the changes permanently and free second level's resources.
what's happening right now is until first level transaction is not committed it neither free second level's resources nor commit second level's changes permanently.

I am getting new id in second level which i want to committ as soon as its done. so other network users can access the table. so at second level i want a transaction that is independant of other active transaction.
is it possible? please let me know.

Thanks
Mark