Re: trigger status=INVALID

From: jo <jose.soares_at_sferacarta.com>
Date: Tue, 11 Jan 2011 11:10:38 +0100
Message-ID: <4D2C2C9E.4030107_at_sferacarta.com>

TESTAJ3_at_nationwide.com wrote:
>
> have you attempted to recompile it and then take a look at dba_errors?
Well, I see there's an error, and now I have to find it...

select * from dba_errors;

owner | name                       | type    | sequence | line | 

position | text

----- + -------------------------- + ------- + -------- + ---- + 
-------- + -------------------------------------------------
JOSE  | CERTIFICATI_DELETE_TRIGGER | TRIGGER | 1        | 1    | 97       |

PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
; <an identifier> <a double-quoted delimited-identifier> The symbol ";" was substituted for "end-of-file" to continue. | ERROR | 103
(1 rows)

>
> joe
>
> _______________________________________
> Joe Testa, Oracle Certified Professional
> Senior Engineering & Administration Lead
> (Work) 614-677-1668
> (Cell) 614-312-6715
>
>
>
>
>
> From: jose soares <jose.soares_at_sferacarta.com>
> To: ORACLE-L <oracle-l_at_freelists.org>
> Date: 01/10/2011 11:48 AM
> Subject: trigger status=INVALID
> Sent by: oracle-l-bounce_at_freelists.org
>
>
> ------------------------------------------------------------------------
>
>
>
> 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
>
>
>
>

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

Received on Tue Jan 11 2011 - 04:10:38 CST