HI,
I'm working with TOAD for Oracle 11.5 version of Oracle 11g r2 .
Now I am enclosing sentence if it works when you are not in a alamcenado procedure , and when it is and I run I get the following message:
MERGE INTO TABLA_DESTINO TARGET USING TABLA_ORIGEN@CE SOURCE
ON (TARGET.CODIGO_EXT_AREA = SOURCE.COD_AREA)
WHEN MATCHED THEN
UPDATE SET TARGET.DESCRIPCION = SOURCE.DESC_AREA
WHEN NOT MATCHED THEN
INSERT (CODIGO_EXT_AREA, DESCRIPCION)
VALUES(SOURCE.COD_AREA, SOURCE.DESC_AREA);
[Warning] ORA-24344: success with compilation error
PL/SQL: ORA-00980: synonym translation is no longer valid
(1: 0): Warning: compiled but with compilation errors
I would appreciate your support in order to solve this post .
best regard,
Christian