oracle添加触发器无效,Oracle触发器无效

我是SQL新手，我试图创建一个插入审计表的触发器。

create or replace trigger late_ship_insert

after insert on suborder

for each row

declare

employee int;

begin

select emp_id

into employee

from handles

where order_no = :new.order_no;

if :new.actual_ship_date > :new.req_ship_date then

insert into ship_audit

values (employee, :new.order_no, :new.suborder_no, :new.req_ship_date, :new.actual_ship_date);

end;错误：

Warning: execution completed with warning

trigger late_ship_insert Compiled.但是，一旦我尝试插入语句，它告诉我触发器没有工作它放弃它。

Error starting at line 1 in command:

insert into suborder

values ( 8, 3, '10-jun-2012', '12-jul-2012', 'CVS', 3)

Error at Command Line:1 Column:12

Error report:

SQL Error: ORA-04098: trigger 'COMPANY.LATE_SHIP_INSERT' is invalid and failed re-validation

04098. 00000 - "trigger '%s.%s' is invalid and failed re-validation"

*Cause: A trigger was attempted to be retrieved for execution and was

found to be invalid. This also means that compilation/authorization

failed for the trigger.

*Action: Options are to resolve the compilation/authorization errors,

disable the trigger, or drop the trigger.任何想法是什么导致这一点，任何帮助将不胜感激。谢谢！