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