Yes. I've read this, and I use a startup.pl script to set ENV when Apache starts, and it works fine for ORACLE_HOME. It works if I don't try to set NLS_LANG. The problem is that if NLS_LANG is set properly I can't connect with this strange message in Apache's logs about 'quoted string not properly terminated'
----- Original Message ----- From: "Arnaud Blancher" <[EMAIL PROTECTED]> To: "Jean-Paul COGNET" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, October 26, 2004 3:48 PM Subject: Re: pb setting NLS_LANG with mod_perl 1.99_14et DBD::Oracle > Jean-Paul COGNET wrote: > > > A problem with mod_perl 1.99 et DBD::Oracle. > > > > do you read this ? > > http://perl.apache.org/docs/2.0/user/troubleshooting/troubleshooting.html#C_Libraries_Don_t_See_C__ENV__Entries_Set_by_Perl_Code > > Arnaud > > > I cannot set the value of NLS_LANG > > > > If I set it to any value different from '' then I cannot connect, > > having this log in Apache : > > [Tue Oct 26 12:48:30 2004] [notice] Apache/2.0.47 (Fedora) configured > > -- resuming normal operations > > DBI connect('TOPDEV5','automate',...) failed: ORA-00604: error > > occurred at recursive SQL level 1 > > ORA-01756: quoted string not properly terminated (DBD ERROR: > > OCISessionBegin) at /var/www/perl/automate1.pl line 1119 > > > > If I don't set NLS_LANG it works fine, but of course I have no accent > > ("été" becomes "ete") > > > > It works fine if I don't use mod_perl > > I use $ENV{NLS_LANG}='french_france.WE8ISO8859P1' just before the > > connect and I have accent ("été" stays "été") > > > > Any idea ? > > Thanks you very much. > > > > -- Report problems: http://perl.apache.org/bugs/ Mail list info: http://perl.apache.org/maillist/modperl.html List etiquette: http://perl.apache.org/maillist/email-etiquette.html