I have written the perl script first times. The perl script is called by Unix shell script ( Say X) , and the Unix is called by Oracle. Earlier another unix shell ( Say Y) was called by X and currently we have the requirement to use Perl instead of Y. My perl Script is running fine while I executed it directly from X. But When I try to execute it by calling the Oracle, it is failed, though no error message is displayed. After debugging the perl script, I found that, when ever I use any command related to file ( Like File Exists, Open and Read file) , the script fails. If I remove the file related commands , it is working fine. The syntax in the code seems correct , since I am able to run the script while calling directly or from X. Earlier all the file related commands were successfully executed through Y. Please let me know, whether any configuration is required for Perl ( Or in Oracle) to handle the files ?

Re: [FishMonger] File Handle is not working in Perl while calling from Oracle
[In reply to]

Can't Post

Thanks for your response. I do not have much idea about error handing process. If I run though Unix , I can get the message from "print" or "die" command. Not sure how should I manage it while calling from Oracle. I have a plan to log the error in a file. But not able to read/write any file. Attached is the code. Please verify that.

Re: [FishMonger] File Handle is not working in Perl while calling from Oracle
[In reply to]

Can't Post

Thanks for your valuable advise. Unfortunately the code also is not working and do not generate any error message. Currently we are returning back to shell script due to timeline constraint. If you have any better idea and useful links for the beginners , please share with us. I will try to learn later.