CREATE OR REPLACE TRIGGER display_new_name
BEFORE INSERT OR UPDATE OR DELETE ON baicai FOR each row
DECLARE
NEW_NAME VARCHAR2(24);
BEGIN
NEW_NAME := :NEW.NAME - NVL(:OLD.NAME, 0);
DBMS_OUTPUT.PUT_LINE('The New Name is:' ||''||new_name);
end;
/
有什么错误???
执行后会报错:
SQL> insert into baicai values('test','23', 'wewe');
insert into baicai values('test','23', 'wewe')
ORA-06502: PL/SQL: 数字或值错误 :字符到数值的转换错误
ORA-06512: 在"ZYJK20.DISPLAY_NEW_NAME", line 4
ORA-04088: 触发器 'ZYJK20.DISPLAY_NEW_NAME' 执行过程中出错
|