I've gotten dropped connections for annoying Oracle so many times now it no longer bothers me. I open another connection, try the same act again, and if it blows up again, I know I've hit a roadblock. I generally put it in reverse, turn the wheel a little and try to hit it from a different direction.

I would simply suggest breaking up your script to try to find exactly which command is annoying Oracle. Then see if you can do what you are attempting in a different way. Not very scientific, but probably the quickest way around the problem.

- Chris