Originally posted by abhaysk
u may handle in application for avoiding such errors....

commit regularly in PL/SQL that involves huge TRAN

Abhay.
why would u ever want to frequently commit in a pl/sql loop?
You significantly increase the chance of ora-1555 and put the brakes
on performance

steve