Re: dbi_link help

From: Richard Huxton <dev@archonet.com>
Subject: Re: [GENERAL] dbi_link help
To: sharmi_jo@yahoo.com
Cc: "General postgres mailing list" <pgsql-general@postgresql.org>
Date: Tuesday, February 10, 2009, 2:51 AM

SHARMILA JOTHIRAJAH wrote:
> When I try to insert into or select from the oracle database I get
> this error...
> 
> ERROR:  error from Perl function "remote_select": error from
Perl
> function "cache_connection": DBI
>
connect('database=postgres;host=...;sid=...;port=1521','postgres',...)
> failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var  or
> PATH(Windows) and or NLS settings, permissions, etc. at line 137 at
> line 13.
> 
> Im not sure what this error is. I had set my ORACLE_HOME, NLS
> settings etc. Is there anything else that needs to be done ?

Is ORACLE_HOME set for the backend process? That's what's trying to
connect. Try setting it globally in /etc/profile if you're having problems.


-- 
Yes ORACLE_HOME is set at .profile..But I still get the errors
-Sharmila