Re: DBI problems.

I'm not clear why you want to set up LIBPATH - is it for another application that requires it?

What was your ORACE_HOME set to when you installed DBD::Oracle? Are you using the same setting when running your Perl script? I never have set LIBPATH, so I'm wondering if the Oracle environment variables are not quite right

Comment on Re: DBI problems.

Replies are listed 'Best First'.
Re: Re: DBI problems. by dbaad (Initiate) on Feb 28, 2004 at 21:14 UTC
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!	[reply]
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	[reply]