Thanks for all the feedbacks.
I guess my script hangs while waiting for input in sqlplus. I tried using DBI but unfortunately it is not installed. I can't install is as it is a production server.
Cheers!