Re: trigger status=INVALID
- From: TESTAJ3@xxxxxxxxxxxxxx
- To: jose.soares@xxxxxxxxxxxxxx
- Date: Mon, 10 Jan 2011 11:53:26 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
