Actually, I'd question this. I get the same error(though i can still
connect). I've even put debuging code into the script that we use to
start apache and it shows that $ORACLE_HOME is properly set when the
script is run.
Just for reference Versions:
Perl 5.6.0
DBI 1.14
DBD::ORACLE 1.06
I haven't felt like chasing down when/where the error is coming from. It
works for now and one error on start up is minor compared to spending the
errors that occure inside the code running the website.
Scott
On Mon, 2 Apr 2001, Sterin, Ilya wrote:
> The browser connects with a user nobody or www or other, since when you
> installed Oracle the ORACLE_HOME was not set for this user, you can either
> set it in the environment or explicitely in you script. A sample script
> would also help.
>
> Ilya Sterin
>
> -----Original Message-----
> From: Charley Wu [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 02, 2001 5:04 PM
> To: [EMAIL PROTECTED]
> Subject: ORACLE_HOME environment variable not set
>
>
> Hello,
>
> I installed Perl DBI and Oracle DBD locally under my own unix directory. I
> wrote a test a script to retrieve data from an Oracle database. The script
> worked perfectly under command line and I got the right data from the
> database. However, when I tried to execute the script from a web page as a
> cgi script, I get the following error: "ORACLE_HOME environment variable not
> set". The script would not work even I set the ORACLE_HOME environment
> variable explicitly in the script. How to solve the problem? Do I need to
> modify the web server configuration file? Thanks in advance for your help.
>
> Charley
>