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

[jesse]

On Wed, Dec 07, 2005 at 04:16:57PM -0300, Luis Campos de Carvalho wrote:
>   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

Ok. First up, can you connect to oracle with DBI from the commandline?
If that's true, does rt's standalone_httpd work?
(And, well, are your ORACLE_HOME and NLS setting right?)