ORA-04098: trigger 'SYSTEM.POLICYPATHTABLE_TRG' is invalid and failed re-validat

[Ak混子]

CREATE OR REPLACE TRIGGER system.policypathtable_trg
BEFORE insert
ON policypathtable
FOR EACH ROW
DECLARE
-- local variables here
BEGIN
delete table policypathtable;
END;


异常是:ORA-04098: trigger 'SYSTEM.POLICYPATHTABLE_TRG' is invalid and failed re-validation
为什么?

[Ak混子]

CREATE OR REPLACE TRIGGER policypathtable_trg
BEFORE insert
ON policypathtable
FOR EACH ROW
DECLARE
-- local variables here
BEGIN
delete table policypathtable;
END;


异常是:ORA-04098: trigger 'SYSTEM.POLICYPATHTABLE_TRG' is invalid and failed re-validation
为什么?

[crazylaa]

delete table policypathtable; ?
drop table ***

[Dave]

[Quote=引用 2 楼 crazylaa 的回复:]
  delete table policypathtable; ?
drop table ***
[/Quote]

修改下试试...




------------------------------------------------------------------------------
Blog： http://blog.csdn.net/tianlesoftware
网上资源： http://tianlesoftware.download.csdn.net
相关视频：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群：62697716

[Ak混子]

[Quote=引用 2 楼 crazylaa 的回复:]
  delete table policypathtable; ?
drop table ***
[/Quote]
不可以哦!不能这样写.语法错误.不能调用DDl语句.