Our application is a data processing one that depends on Oracle. We commit the connection only when all the processing is correct, else rollback. When there is some failure in the network connectivity, we try to connect to Oracle again and start the data processing again. But whats happeneing is different. When we try to reconnect to oracle, we are able to get the connection, but cannot be able to perform any insert operations. The application just hangs when it tries to insert into the table (may be the table is locked). Kindly suggest us a way to proceed with.