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.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
