Place the disconnect from the database and any other cleanup inside of an END{} subroutine. If you need more info, check regular PERL documentation (specifically for END).
Hope this helps. Iman -----Original Message----- From: Agarwal, Ramakant [mailto:[EMAIL PROTECTED]] Sent: Monday, September 02, 2002 11:02 AM To: '[EMAIL PROTECTED]' Subject: doubt Hi all, I require your help regarding the following I have a perl script which is connecting to an Oracle database and is executing different queries. I am using Oraperl for executing different queries. I want that if someone kills the process while the script is in execution then it should log off from the database and then should exit. Does the log off from the db happen automatically whenever a process is killed or we do need to explicitly handle this? Thanks, Ramakant