trigger status=INVALID

From: jose soares <jose.soares@xxxxxxxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 10 Jan 2011 17:49:28 +0100

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

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

Follow-Ups:
- Re: trigger status=INVALID
  - From: TESTAJ3

Other related posts:

» trigger status=INVALID - jose soares
» Re: trigger status=INVALID- TESTAJ3
» Re: trigger status=INVALID- jo
» Re: trigger status=INVALID- jo
» RE: trigger status=INVALID- Dunbar, Norman (Capgemini)
» Re: trigger status=INVALID- jo