...
- Остановите работу адаптера NavXLv5.
Выполните скрипт ниже.
Блок кода language sql DECLARE vCnt number; begin for cur in ( select 'vw_FX'as obj_alias,'FX' as obj_name from dual union all select 'vw_DP'as obj_alias,'DP' as obj_name from dual union all select 'vw_T_TRANSACTIONS'as obj_alias,'TRANSACTIONS' as obj_name from dual union all select 'vw_MRG_FX'as obj_alias,'FX' as obj_name from dual union all select 'vw_MRG_DP'as obj_alias,'DP' as obj_name from dual union all select 'vw_MRG_ORDERS'as obj_alias,'ORDERS' as obj_name from dual union all select 'vw_MRG_CUSTOMER'as obj_alias,'CUSTOMER' as obj_name from dual union all select 'vw_SEC_DEAL'as obj_alias,'SEC_DEAL' as obj_name from dual union all select 'vw_INET_CLIENTS'as obj_alias,'CUSTOMER' as obj_name from dual union all select 'vw_SEC_MARKET'as obj_alias,'ONLINEQUOTATIONS' as obj_name from dual union all select 'vw_CUSTOMER'as obj_alias,'CUSTOMER' as obj_name from dual union all select 'vw_INSTRUMENT'as obj_alias,'INSTRUMENT' as obj_name from dual union all select 'vw_NOSTRO'as obj_alias,'NOSTRO' as obj_name from dual union all select 'vw_CBRATES'as obj_alias,'CBRATES' as obj_name from dual union all select 'vw_PAYMENTS'as obj_alias,'PAYMENTS' as obj_name from dual union all select 'CLIENTS'as obj_alias,'CUSTOMER' as obj_name from dual union all select 'DEALS'as obj_alias,'FX' as obj_name from dual union all select 'ORDERS'as obj_alias,'ORDERS' as obj_name from dual union all select 'CUSTOMER'as obj_alias,'CUSTOMER' as obj_name from dual union all select 'CUST'as obj_alias,'CUSTOMER' as obj_name from dual union all select 'ACCOUNT'as obj_alias,'NOSTRO' as obj_name from dual union all select 'ACC'as obj_alias,'NOSTRO' as obj_name from dual union all select 'TRANSACTION'as obj_alias,'TRANSACTIONS' as obj_name from dual union all select 'PAYM'as obj_alias,'TRANSACTIONS' as obj_name from dual union all select 'T_TRANSACTIONS'as obj_alias,'TRANSACTIONS' as obj_name from dual union all select 'vw_SEC_COUPON'as obj_alias,'INSTRUMENTCASHFLOW' as obj_name from dual union all select 'vw_CONTRACT'as obj_alias,'CONTRACTS' as obj_name from dual union all select 'vw_USER'as obj_alias,'USERS' as obj_name from dual union all select '8AD435DF50C51DD205EC5505DDFAB266'as obj_alias,'CONTROLROW' as obj_name from dual union all select 'LOANS'as obj_alias,'DP' as obj_name from dual union all select 'PAYMENTS'as obj_alias,'TRANSACTIONS' as obj_name from dual union all select 'vw_STATUS'as obj_alias,'STATUS' as obj_name from dual union all select 'vw_ACCBALANCE'as obj_alias,'ACCBALANCE' as obj_name from dual ) loop LOOP IF cur.obj_name = 'CONTROLROW' then update LIC_BUS_OBJ_ALIAS setTHEN UPDATE lic_bus_obj_alias SET obj_alias = cur.obj_alias where WHERE obj_name = cur.obj_name; continue; end if; SELECT count (1) INTO vcnt from LIC_BUS_OBJ_ALIAS where CONTINUE; END IF; SELECT COUNT(1) INTO vcnt FROM lic_bus_obj_alias WHERE obj_alias = cur.obj_alias; if IF vcnt >0> then0 update LIC_BUS_OBJ_ALIAS setTHEN UPDATE lic_bus_obj_alias SET obj_name = cur.obj_name where WHERE obj_alias = cur.obj_alias; else ELSE INSERT INTO LIClic_BUSbus_OBJobj_ALIASalias ( obj_alias, obj_name) ) VALUES ( cur.obj_alias, cur.obj_name ); end if; end loop END IF; END LOOP; end; /
- Запустите адаптер и убедитесь, что ошибка устранена.
...