我有一些错误.我不知道是什么:/(甲骨文)

Question

我为视频俱乐部写了这篇文章(家庭作业(

CREATE TABLE FILMS (
TITLE VARCHAR (35),
GENDER VARCHAR (15),
MANAGERVARCHAR (20),
ACTORS VARCHAR (90),
COPYS INT)
CREATE TABLE LOAN (
ID_LOAN INT,
ID_PARTNER INT,
FILM_LOAN VARCHAR (35),
DATE_LOAN DATE,
ID_COPY INT
) 
CREATE OR REPLACE TRIGGER LESS_COPY
AFTER INSERT ON LOAN 
FOR EACH ROW 
BEGIN 
UPDATE FILM SET FILMS.COPYS = FILMS.COPYS - 1
WHERE FILMS.TITLE = LOAN.FILM_LOAN
END

甲骨文给我这个

Warning: Trigger created with compilation errors.

我需要帮助来修复此:(

Answer 1

查询USER_ERRORS视图以查看编译错误。

在这种情况下，我注意到您的触发器主体显示UPDATE FILM ...但表名是 FILMS .

Answer 2

此外，更新语句末尾没有 ";">