Hi!
We have a simple problem here and I hope with a simple solution. We are running a perl script using the UNIX scheduler (crontab). This script is importing information from a file and sending this information in an Oracle DB.
If I run the script manually (without the scheduler) everything works fine. If I run the script using the scheduler I get a core dump. We discovered some part of the problem. It seems that when we are using the scheduler, the UNIX ORACLE environment variables are different. This cause to have a different ORACLE home variable which create a problem.
We tried modifying on the fly (just before running the script with the scheduler) these variables but it's not working. Any ideas or suggestions?
Any help would be appreciated,
Thanks
Chris ;-)
We have a simple problem here and I hope with a simple solution. We are running a perl script using the UNIX scheduler (crontab). This script is importing information from a file and sending this information in an Oracle DB.
If I run the script manually (without the scheduler) everything works fine. If I run the script using the scheduler I get a core dump. We discovered some part of the problem. It seems that when we are using the scheduler, the UNIX ORACLE environment variables are different. This cause to have a different ORACLE home variable which create a problem.
We tried modifying on the fly (just before running the script with the scheduler) these variables but it's not working. Any ideas or suggestions?
Any help would be appreciated,
Thanks
Chris ;-)