Postgres Pro
Downloads
Home   >   mailing lists

dbi_link help - Mailing list pgsql-general

From SHARMILA JOTHIRAJAH
Subject dbi_link help
Date
Msg-id 793670.12754.qm@web110702.mail.gq1.yahoo.com
Whole thread Raw
Responses Re: dbi_link help
Re: dbi_link help
List pgsql-general
Tree view
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


pgsql-general by date:

Previous
From: paulo matadr
Date:
Subject: Query for describe locks
Next
From: "Matt Magoffin"
Date:
Subject: Re: Out of memory on SELECT in 8.3.5