Hi,
I got 2 objects in different schema
1) Master object in Test1 schema (Primary Key is EmployeeID)
2) History object in Test2 schema (Foreign Key is EmployeeID)
But i when i tried to execute below trigger, getting some exception
CREATE OR REPLACE TRIGGER TRIGGER1
AFTER INSERT ON Test1.abc
for each row
BEGIN
insert into Test2.def (EmployeeID) values ( :NEW."EmployeeID" );
END;
1st Error: Error(2,2): PL/SQL: SQL Statement ignored
2nd Error: Error(2,22): PL/SQL: ORA-00942: table or view does not exist
Any suggestions!
THanks