Thanks Richard --- On Tue, 2/10/09, Richard Huxton <d...@archonet.com> wrote: From: Richard Huxton <d...@archonet.com> Subject: Re: [GENERAL] dbi_link help To: sharmi...@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