RE: DBD:Oracle question

i have those env variables set. I guess you are right...the cron job is not able to access those.
i will set it explicitly in the program.

Thank you
K



> Date: Wed, 30 Jan 2008 11:51:24 -0500
> From: [email protected]
> To: [email protected]
> CC: [email protected]
> Subject: Re: DBD:Oracle question
> 
> Off the top of my head I would say it is a permission error or your 
> environment variables are not set.  When running from Cron you do not 
> have the values in you .proflile set so you will have to set them in the 
> .pl  you will need I think ORACLE_HOME and LD_LIBRARY_PATH to be set in 
> you program
> 
> Kiran Annaiah wrote:
> > Hello,
> >
> > I have perl program which connects to the Oracle DB. It seems to run fine when i run it from its directory. But when i set up the program as a CRON JOB it fails to run.
> > Tries to execute but gives this error and quits -
> >
> > -------------------------------------------------------------------------------------------
> > Can't load '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libocci.so.10.1: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
> >  at /home/kiran/projects/ORACLE_TO_MYSQL_table_copy/subject_form/copy_subjFormTable_fromOraToMysql.pl line 5
> > Compilation failed in require at /home/kiran/projects/ORACLE_TO_MYSQL_table_copy/subject_form/copy_subjFormTable_fromOraToMysql.pl line 5.
> > BEGIN failed--compilation aborted at /home/kiran/projects/ORACLE_TO_MYSQL_table_copy/subject_form/copy_subjFormTable_fromOraToMysql.pl line 5.
> > --------------------------------------------------------------------------------------------
> >
> >
> > I do have the Oracle.so shared library file in the location specified above. 
> > Wondering why it is failing to load, considering that it  program runs fine from its directory.
> >
> > thank you all
> > Kiran
> >
> >
> >
> >
> > _________________________________________________________________
> > Connect and share in new ways with Windows Live.
> > http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008
> >   
> 
> -- 
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe:    http://lists.mysql.com/[email protected]
> 

_________________________________________________________________
Climb to the top of the charts! Play the word scramble challenge with star power.
http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan