Настройка соединения между Postgresql и Oracle через Dbi-link

При выполнении скрипта :
/*
* 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'
;

SELECT make_accessor_functions(
'dbi:Oracle:mmvdb;host=10.0.7.132;sid=mmvdb; port=1521',
'ae',
'ae',
'---
AutoCommit: 1
RaiseError: 1
',
'---
- env_name: ORACLE_HOME
env_value: D:/ORACLE/product/10.2.0/client1
env_action: overwrite
- env_name: NLS_LANG
env_value: AMERICAN_AMERICA.CL8MSWIN1251
env_action: overwrite
- env_name: NLS_DATE_FORMAT
env_value: "YYYY-MM-DD HH24:MI:SS"
env_action: overwrite
- env_name: NLS_TIMESTAMP_FORMAT
env_value: "YYYY-MM-DD HH24:MI:SS.FF"
env_action: overwrite
- env_name: NLS_TIMESTAMP_TZ_FORMAT
env_value: "YYYY-MM-DD HH24:MI:SS.FF TZH"
env_action: overwrite
- env_name: TNS_ADMIN
env_value: D:/ORACLE/product/10.2.0/client1/network/admin
env_action: overwrite
- env_name: LDAP_ADMIN
env_value: D:/ORACLE/product/10.2.0/client1/ldap/admin
env_action: overwrite',
NULL,
NULL,
'test'
);

Выдает ошибку:

ERROR: value for domain yaml violates check constraint "yaml_check"
Подскажите пожалуйста как это исправить?

Back to top

(С) Виктор Вислобоков, 2008-2023