When I need to have a "use DBD::Oracle qw(:ora_types);" in my program, and I
am running from cron, I get a message like:
Can't load '<long path>/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle:'
at the use DBD::Oracle line.
Other programs that just have a 'use DBI' are fine. The normal program
structure I have so that programs work from cron is like:
use DBI;
....
<setup Oracle variables, including LD_LIBRARY_PATH>
....
$dbh=DBI->connect($dsn, $username, $password, { ora_module_name => $me })
....
etc
but as soon as I add;
use DBD::Oracle qw(:ora_types);
I get the error, because the symbol import is done at compile time, before
my program has had a chance to set up the environment properly.
Any ideas how to get around this problem? So far I am explicitly setting
LD_LIBRARY_PATH in the crontab entry, but I was trying to have it all happen
inside the program.
Australia Post is committed to providing our customers with excellent service. If we
can assist you in any way please either telephone 13 13 18 or visit our website
www.auspost.com.au.
CAUTION
This e-mail and any files transmitted with it are privileged and confidential
information intended for the use of the addressee. The confidentiality and/or
privilege in this e-mail is not waived, lost or destroyed if it has been transmitted
to you in error. If you have received this e-mail in error you must (a) not
disseminate, copy or take any action in reliance on it; (b) please notify Australia
Post immediately by return e-mail to the sender; and (c) please delete the original
e-mail.
