Jul 30, 2010, 3:26 AM
Post #1 of 7
File Handle is not working in Perl while calling from Oracle
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 ?
Thanks in Advance