I am a freshman, just contact database
The problems in creating a trigger is
Errors: check the compiler log
The TRIGGER TEST. TRI_DEL_CJ error:

The LINE/COL ERROR
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
2/1 of the PL/SQL: SQL Statement ignored
PL/SQL: 2/8 ORA - 00942: table or view there is no

The search on the net, said may authority has a problem, after I gave it to or not, has always been the question
The trigger code below
The CREATE OR REPLACE the TRIGGER TRI_DEL_SCORE AFTER DELETE ON STUDENT
FOR EACH ROW
The BEGIN
The DELETE FORM SCORE WHERE SNO=: OLD. SNO.
END;

SHOW the ERRORS;
The DELETE FROM SCORE WHERE SNO='201801';
The CREATE OR REPLACE the TRIGGER TRI_DEL_SCORE2 AFTER DELETE ON COURSE FOR EACH ROW
The BEGIN
The DELETE FORM SCORE WHERE CNO=: OLD. CNO;
END;
/

CodePudding user response:

2/8: ORA - 00942: table or view there is no


Look at the prompt, tables and views do not exist,

SCORE this table, there?

CodePudding user response:

SCORE of other users are listed in the table? So to the SCHEMA in the forefront of the SCORE, such as SCOTT. The SCORE

CodePudding user response:

reference 1st floor selling fruit net reply:

2/8: ORA - 00942: table or view there is no


Look at the prompt, tables and views do not exist,

SCORE this table, there?

Under the table, I again another user can create a trigger, but not under this user

CodePudding user response:

Half a month, still not solve?

Under another user, the user can't (currently logged in user),

Obviously, the table owner is another user, not the user,

CodePudding user response:

references 4 floor selling fruit net reply:

half a month, still not solve?

Under another user, the user can't (currently logged in user),

Obviously, the table owner is another user, not the user,

Emm, check the score table, users belonging to the text, that is, the current user, the problem has been solved, specific how to solve the forgotten, like what did after the grant, thank you for your big help