Re: trigger status=INVALID
- From: jo <jose.soares@xxxxxxxxxxxxxx>
- To: Ravindranath Seetharamagowdu <sraveenderan@xxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 11 Jan 2011 10:59:47 +0100
In particular, what do I need to check, Ravindranath?
This table is empty (0 rows)
here its descr...
Do you see something strange in it?
The trigger has the goal to avoid deletion from a row which has the
NR_BOLLETTA field not null.
table: PRESTAZIONE
name | data_type | nullable |
data_default | data_length
------------------------- + --------------------------- + -------- +
----------------- + -----------
AA_BOLLETTA | NUMBER | Y |
NULL | 38
CODICE_OPERATORE | NUMBER | N |
NULL | 38
DATA | DATE | N |
NULL | 11
ID | NUMBER | N |
NULL | 38
ID_OPERATORE | NUMBER | N |
NULL | 38
ID_SOPRALLUOGO | NUMBER | Y |
NULL | 38
ID_TARIFFA | NUMBER | N |
NULL | 38
ID_TIPOLOGIA_ESPORTAZIONE | NUMBER | Y |
NULL | 38
ID_UNITA_AZIENDALE | NUMBER | N |
NULL | 38
IMPORTO | NUMBER | Y |
NULL | 12.3
MAG_NOTTURNO_FESTIVO | NUMBER | Y |
NULL | 5.2
NOTE | VARCHAR2 | Y |
NULL | 200
NR_BOLLETTA | NUMBER | Y |
NULL | 38
PAESE_DESTINAZIONE | VARCHAR2 | Y |
NULL | 3
PAESE_TRANSITO | NUMBER | Y |
NULL | 38
PROTOCOLLO | VARCHAR2 | Y |
NULL | 250
QUANTITA | NUMBER | Y |
NULL | 15.3
QUANTITA_NOTTURNO_FESTIVO | NUMBER | Y |
NULL | 38
RIMBORSO | NUMBER | Y |
NULL | 12.3
SCONTO | NUMBER | Y |
NULL | 5.2
SEZIONALE | VARCHAR2 | Y |
NULL | 3
TIPO_PAGAMENTO | VARCHAR2 | Y |
NULL | 5
TS_ULTIMA_MODIFICA | TIMESTAMP(6) WITH TIME ZONE | Y |
current_timestamp | 13
Ravindranath Seetharamagowdu wrote:
Please check the respective table present in the database.
Regards
SR
--- On *Mon, 10/1/11, jose soares /<jose.soares@xxxxxxxxxxxxxx>/* wrote:
From: jose soares <jose.soares@xxxxxxxxxxxxxx>
Subject: trigger status=INVALID
To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
Date: Monday, 10 January, 2011, 4:49 PM
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
--
Jose Soares
Sferacarta Net
Via Bazzanese 69
40033 Casalecchio di Reno
Bologna - Italy
Ph +39051591054
fax +390516131537
web:www.sferacarta.com
Le informazioni contenute nella presente mail ed in ogni eventuale file allegato
sono riservate e, comunque, destinate esclusivamente alla persona o ente
sopraindicati, ai sensi del decreto legislativo 30 giugno 2003, n. 196. La
diffusione, distribuzione e/o copiatura della mail trasmessa, da parte di qualsiasi
soggetto diverso dal destinatario, sono vietate. La correttezza, l'integrità e
la sicurezza della presente mail non possono essere garantite. Se avete ricevuto
questa mail per errore, Vi preghiamo di contattarci immediatamente e di eliminarla.
Grazie.
This communication is intended only for use by the addressee, pursuant to
legislative decree 30 June 2003, n. 196. It may contain confidential or
privileged information. You should not copy or use it to disclose its contents
to any other person. Transmission cannot be guaranteed to be error-free,
complete and secure. If you are not the intended recipient and receive this
communication unintentionally, please inform us immediately and then delete
this message from your system. Thank you.
Other related posts:
