Using DBI from within Apache

Hello

Please help. I have loaded the latest DBI and DBD::Oracle modules.
These have compiled and installed successfully and I have a program
that logs into my database and works fine from the command line. This
is as long as I have the environment variables ORACLE_HOME and
LD_LIBRARY_PATH set and exported. However I cannot call the program
as a CGI program from my Apache server. My CGI directory is properly
configured in that I can call other CGI programs with no problem. I
have stopped the httpd daemon and started it again with those
environment variables set and exported but to no avail.
I get the following error in the error_log.

install_driver(Oracle) failed: Can't load
'/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBD/Oracle/Oracle.so'
for module DBD:Oracle: libclntsh.so.8.0: cannot load shared object
file: No such file or directory at
/usr/lib/perl5/5.6.0/i386-linus/Dynaloader.pm line 200. at (eval 1)
line 3

The shared library libclntsh.so.8.0 exists in the directory
/home/oracle/product/8.1.6/lib which is what the LD_LIBRARY_PATH is
set to. My question is really how do I get the LD_LIBRARY_PATH set
when my CGI programs run?

Thanks in advance

Hog Spog