The create or replace the trigger CHG_STA
AFTER the UPDATE ON TETS1
FOR EATCH ROW
DECLARE TEST_COUNT NUMBER;

The BEGIN SELECT COUNT (*) INTO TEST_COUNT FROM TEST2 WHERE ID=: NEW. ID;
IF TEST_COUNT=0 THEN
The UPDATE TEST3 SET ID=: NEW. ID;
End the if;
end;

Test2 trigger updates test1;
This trigger execution time, abnormal, 04091 test2 number change, the trigger can't read

CodePudding user response:

For help, how to solve

CodePudding user response:

Trigger, can't read the data in this table, you want to change the logic!


Get the trigger on the test2 hair up to look at it!

CodePudding user response:

Test2 update test1 and test2 test1 read data, update the test3
The equivalent of test2 trigger to get their own data,
On the basis of business change implementation logic

CodePudding user response:

Too many Test2 triggers, Test2 data, data part parameters of test1 need,