Help with DBIx::SearchBuilder::Handle::Oracle...

Luis Campos de Carvalho monsieur_champs at
Wed Dec 7 19:16:57 GMT 2005

  Hi londoners & friends

  I'm getting a bit passed with this problem.
  My client insisted in using that RHEL 4.0 linux distro:

Linux machine 2.6.9-5.ELsmp #1 SMP Wed Jan 5 19:30:39 EST 2005 i686 GNU/Linux

  And I'm using this perl:
  my perl5 (revision 5 version 8 subversion 5)

  And trying (hard) to connect to an Oracle database trought DBIx::SearchBuilder. But it
keeps screaming this error:

DBI connect('host=;sid=DEVEL','rt',...) failed: 
ERROR OCIEnvNlsCreate (check ORACLE_HOME and NLS settings etc.)
at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/
line 108
[Wed Dec 7 16:51:34 2005] [error] Connect Failed ERROR
OCIEnvNlsCreate (check ORACLE_HOME and NLS settings etc.) at /usr/local/rt/lib/ line 176

  And I don't have any ideas of what's going wrong anymore.
  Ah! My VirtualHost is like this:

<VirtualHost machine:80>
    ServerName machine.local
    DocumentRoot /usr/local/rt/share/html
    AddDefaultCharset UTF-8

    PerlSetEnv ORACLE_HOME /opt/oracle/software/
    PerlModule Apache::DBI
    PerlRequire /usr/local/rt/bin/

    <Location />
      SetHandler perl-script
      PerlHandler RT::Mason

  Any suggestions, pointers, work-arrounds and tips are welcome.
  Many thanks in advance.

Luis Campos de Carvalho
Member of "São Paulo Perl Mongers",
Unix SysAdmin & OCP/DBA Oracle


Yahoo! doce lar. Faça do Yahoo! sua homepage. 

More information about the mailing list