On Sat, May 29, 2010 at 12:19, Bobak, Mark <mark.bo...@proquest.com> wrote: > I'd argue you want to use a shell wrapper anyhow, because rather than setting > those variables explicitly, you ought to do something like: > export ORACLE_SID=your_sid > export ORAENV_ASK=NO > . oraenv > > and Oracle will set it all for you, and if/when something changes or is > upgraded, your code will continue to do the right thing. snip
Yeah, using a wrapper shell script to setup the environment is always a good idea. I have seen too many Perl scripts (and C programs) fail miserably when run by cron because they assumed some environment would be present. This would also be a good place to set PERL5LIB and any other variables you need to exist. -- Chas. Owens wonkden.net The most important skill a programmer can have is the ability to read.
