Thanks for your reply, the problem is not I got disconnect and reconnect and run.

The problem is my connection will be disconnect everytime I ran this insert statement. I do believe that it's a bug in ORacle

by the way, I am running 8.1.7 on windows 2000 server.