触发器问题

huasoft

代码如下:
drop table personal;
create table personal(password varchar(5) not null, NAME varchar2(15) not null, num long, salary number(10), others varchar2(30));

INSERT INTO personal(password, NAME, num, salary, others)VALUES('101', 'GZH', '1', 2400, null);
COMMIT;

CREATE OR REPLACE TRIGGER Writelog1
        AFTER DELETE OR UPDATE
                ON personal FOR EACH ROW
DECLARE
        passwordchar(1);
BEGIN
        if UPDATE then
                passwordchar := 'U';
        else
                passwordchar := 'D';
        end if;
        INSERT INTO writelog VALUES(passwordchar, USER, SYSDATE);
END Writelog1;




SQL>; CREATE OR REPLACE TRIGGER Writelog1
  2   AFTER DELETE OR UPDATE
  3    ON personal FOR EACH ROW
  4  DECLARE
  5   passwordchar(1);
  6  BEGIN
  7   if UPDATE then
  8    passwordchar := 'U';
  9   else
10    passwordchar := 'D';
11   end if;
12   INSERT INTO writelog VALUES(passwordchar, USER, SYSDATE);
13  END Writelog1;
14  /

警告: 创建的触发器带有编译错误。


请高手指点,谢谢!!!!!!11

sshd

SQL>; show errors

to see what the error is

viton_xuan

passwordchar(1); 可以这样吗?
版主说得对,用toad那些软件可以查出是哪里出了什么错的