Re: trigger status=INVALID

have you attempted to recompile it and then take a look at dba_errors?

joe

_______________________________________
Joe Testa, Oracle Certified Professional 
Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715






From:
jose soares <jose.soares@xxxxxxxxxxxxxx>
To:
ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date:
01/10/2011 11:48 AM
Subject:
trigger status=INVALID
Sent by:
oracle-l-bounce@xxxxxxxxxxxxx



Hi all,

I created successful a trigger like this one in the db:

CREATE OR REPLACE TRIGGER certificati_delete_trigger
BEFORE DELETE ON prestazione
    FOR EACH ROW
BEGIN
    IF :old.nr_bolletta IS NOT NULL THEN
        RAISE_APPLICATION_ERROR(-20000, 'errror');
    END IF;
END


but it has the status=INVALID

select * from dba_objects where object_type = 'TRIGGER' and status = 
'INVALID'

owner | object_name                | object_type | status  | temporary | 
generated | secondary
----- + -------------------------- + ----------- + ------- + --------- + 
--------- + ---------
JOSE  | CERTIFICATI_DELETE_TRIGGER | TRIGGER     | INVALID | N         | 
N         | N
(1 rows)


What's wrong with it?

j

--
http://www.freelists.org/webpage/oracle-l

Other related posts: