Im not sure if this is the right place to ask about dbi_link. If not please forward it there.
Im trying to create a dbi_link between Oracle and postgresql. i nistalled all the necessary perl packages And I had run dbi_link.sql and it completed without any errors
This is sql that I use to connect postgres@garuda:~$ less /home/postgres/dbi-link-2.0.0/examples/oracle/dola.sql /* * Data source: dbi:Oracle:hr;host=localhost;sid=xe * User: hr * Password: foobar * dbh attributes: {AutoCommit => 1, RaiseError => 1} * dbh environment: NULL * remote schema: NULL * remote catalog: NULL * local schema: hr */
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' ;