Monday, 19 August 2013

oracle create a trigger

oracle create a trigger

In oracle database: I tried the following query:
CREATE or REPLACE TRIGGER myTrigger
AFTER UPDATE OR INSERT ON product
REFERENCING NEW AS NEW
FOR EACH ROW
BEGIN
INSERT INTO h_product
(
H_PRODUCT_ID,
PRODUCT_ID
)
VALUES
(
seq_h_product.nextval,
new.product_id
);
END
when I execute, I get this error:
3:56:45 [UPDATE - 0 row(s), 0.000 secs] [Error Code: 4098, SQL State:
42000] ORA-04098: Déclencheur 'NEILA.myTrigger' non valide. Echec de la
revalidation
I execute :
select object_name
from dba_objects
where object_type = 'TRIGGER'
and status = 'INVALID';
=> I get myTrigger in the list ! why is it invalid?

No comments:

Post a Comment