A problem with mod_perl 1.99 et DBD::Oracle.
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é")
What do you get when you print that value from a modperl script? Does it show the right setting?
Any difference if you use Env::C (from CPAN) to set it (it doesn't do any locking, but you shouldn't have a problem, if you are using a prefork mpm.
In any case, before you continue trying, please first upgrade to 1.99_17 so we are on the same line.
-- __________________________________________________________________ Stas Bekman JAm_pH ------> Just Another mod_perl Hacker http://stason.org/ mod_perl Guide ---> http://perl.apache.org mailto:[EMAIL PROTECTED] http://use.perl.org http://apacheweek.com http://modperlbook.org http://apache.org http://ticketmaster.com
-- 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
