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

[Luis Campos de Carvalho]

  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 10.2.0.1 database trought DBIx::SearchBuilder. But it
keeps screaming this error:

DBI connect('host=192.168.87.20;sid=DEVEL','rt',...) failed: 
ERROR OCIEnvNlsCreate (check ORACLE_HOME and NLS settings etc.)
at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm
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/RT.pm 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/10.2.0.1
    PerlModule Apache::DBI
    PerlRequire /usr/local/rt/bin/webmux.pl

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

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

--
Luis Campos de Carvalho
Member of "São Paulo Perl Mongers",
Unix SysAdmin & OCP/DBA Oracle
http://br.geocities.com/monsieur_champs/


	



	
		
_______________________________________________________ 
Yahoo! doce lar. Faça do Yahoo! sua homepage. 
http://br.yahoo.com/homepageset.html