From: | SHARMILA JOTHIRAJAH <sharmi_jo(at)yahoo(dot)com> |
---|---|
To: | General postgres mailing list <pgsql-general(at)postgresql(dot)org> |
Subject: | dbi_link help |
Date: | 2009-02-09 19:11:56 |
Message-ID: | 793670.12754.qm@web110702.mail.gq1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
Im new to dbi_link. I had installed dbi_link and run the dbi_link.sql script . This is the script that I ran after that and it didn't have any errors. Now the schemas dbi_link and EMPLOYEE are created in my postgres database. The user is "postgres" in both the databases with the same password in both.
UPDATE
pg_catalog.pg_settings
SET
setting =
CASE WHEN 'dbi_link' = ANY(string_to_array(setting, ','))
THEN setting
ELSE 'dbi_link,' || setting
END
WHERE
name = 'search_path'
;
SELECT make_accessor_functions(
'dbi:Oracle:database=postgres;host=...;sid=....;port=1521',
'postgres',
'postgres',
'---
AutoCommit: 1
RaiseError: 1
',
NULL,
NULL,
NULL,
'employee'
);
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 ?
Thanks
Sharmila
From | Date | Subject | |
---|---|---|---|
Next Message | paulo matadr | 2009-02-09 19:12:40 | Query for describe locks |
Previous Message | Tom Lane | 2009-02-09 18:25:54 | Re: Convert Arbitrary Table to Array? |