I upgrade with the new version of Apache 2.0 (httpd-2.0.52) and mod_perl
1.99_17 and the behaviour is exactly the same.
If I set NLS_LANG I obtain this logs just before connect
ORACLE_HOME=/opt/oracle/product/10g/OraDB10g
NLS_LANG=french_france.WE8ISO8859P1
I cannot connect and have this log in Apache
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 1126
If I do not set NLS_LANG I obtain this logs just before connect
ORACLE_HOME=/opt/oracle/product/10g/OraDB10g
NLS_LANG=
and then I can connect but "été" becomes "ete"
Many Thanks for yoyr help.
----- Original Message -----
From: "Stas Bekman" <[EMAIL PROTECTED]>
To: "Jean-Paul COGNET" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, October 28, 2004 12:58 AM
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.
> >
> > 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
>
--
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
