in reply to Re: DBI problems.
in thread DBI problems.

users (dbas) who execute this script will likely be logged in as oracle. user oracle sets LIBPATH in profile on login and it is required for some dba functions (it's a standard at our shop to set this).

there are several oracle homes (and LIBPATH and other envs) that can be set depending on the db being accessed on the box. i can work with different ORACLE_HOME's no problem.

sometimes i use the same environment, sometimes not. it seems as long as LIBPATH is unset, i don't have a problem.

i want to be able to unset it, or handle the exception and print a notice to the user to unset it and run script again. that's where my problem is, i can't find a way to handle install_driver.

thanks for the help!

Replies are listed 'Best First'.
Re: Re: Re: DBI problems.
by astroboy (Chaplain) on Mar 01, 2004 at 10:29 UTC
    I'm not quite clear why LIBPATH is set. I set it (or LD_LIBRARY_PATH, depending on the OS), when I install Oracle or DBD::Oracle, but this is done manually just prior to installation. I do not set it in the profile, and it is not set for using Oracle on a day-to-day basis. I wonder if you are using some application that requires it. If you're not sure, why don't you unset it in your test system, and see if anything breaks