note afoken <p>If you set up Oracle environment variables inside a script that loads the Oracle client libraries, you have to set up the variables <b>before</b> the libraries are loaded:</p> <ul> <li>You can set up <c>%ENV</c> in a <c>BEGIN</c> block, at least before loading [mod://DBD::Oracle] implicitly via <c>DBI->connect()</c> or explicitly, better even before loading [mod://DBI].</li> <li>You can wrap your script in a shell script that sets the variables before passing control to your script via <c>exec</c>.</li> <li>You can add <c>PassEnv</c> or <c>SetEnv</c> directives to the Apache configuration.</li> </ul> <p>I prefer the last way, so no script has to be modified and all scripts automatically get the right Oracle configuration.</p> <p>Alexander</p> <div class="pmsig"><div class="pmsig-747201"> --<br> Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-) </div></div> 848015 848034