Actually the ORACLE HOME path was set wrong in a profile file called by my program. I was connecting to a different instance of the database in the new script.
One of my shell scripts was working fine till a few days back. It was scheduled in the cron. But yesterday i made some modifications to the script. The script works fine when i run it...