Triggers - stopped working

[fbarros300472]

Environment Information:
* Oracle version: 10 g
* Operating system: Linux


Good morning everyone!

The triggers I have on a database simply stopped working .... very strange. Would anyone have an idea of ??what it can be?

[dr_gori]

Are triggers disabled?

Select all

SQL> select status, count(*) 
  2  from all_triggers 
  3  group by status 
  4  / 
 
STATUS     COUNT(*) 
-------- ---------- 
DISABLED         61 
ENABLED        3196 
 
SQL> 

[fbarros300472]

They are all enabled. This is strange.

[fbarros300472]

And there guys, no one has a tip .... please.

[luptak]

Dude ... It may seem half a beast, but checks if all today tables exist or if the Owners are right ...
Was there any change in these triggers?

[elidias7]

Good afternoon.

Another guess, are not invalid, refer to DBA_Objects

Hugs,

[luptak]

Exactly ... I just came across the same situation.

Select all

select * from dba_objects where object_type = 'TRIGGER';

[fbarros300472]

Because it's personal, I did the Select, but it's all ok ..... I'll do a drop of them and generate them again ..... anyway thank you very much the availability of you in helping me .... so to finish, I give back ... Thanks.

[fbarros300472]

Good Morning !
Deleted and I created again ..... They do not work ... Someone please would have any suggestions to that?

Thanks.

[dr_gori]

There goes an idea:
* has already happened to have more than one trigger of the same type in the same table. Hence he gave some kind of "conflict" that he did not perform the others. The solution was to join the triggers of the same type in a single trigger ... (I do not know if this is happening there)

face ... sincerely, I never heard of it before, from trigger Stop working.

Have you tried to make a zero trigger for testing? Type:
* Creates a table any
* Creates a trigger in this table with some code Easy to track ...

Then see if in a common table, it's working ... because you said that on the bench all triggers stopped working ... Take the test with one!

Something like this:

Select all

SQL> create table thomas (campo varchar2(100)); 
 
Table created. 
 
SQL> create trigger trg_thomas after insert on thomas FOR EACH ROW 
  2  begin 
  3    dbms_output.put_line('***chegou aqui***'); 
  4  end; 
  5  / 
 
Trigger created. 
 
SQL> set serveroutput on 
SQL> insert into thomas values ('teste'); 
***chegou aqui*** 
 
1 row created. 
 
SQL> 

Then shows us what happens in the same situation!

[luptak]

or will recreando one to one and testing individually

[fbarros300472]

Good afternoon people !

I was able to solve the problem ..... I had a condition that was not being taken care of and because of that she was going straight. I did not quite understand why, but I'm working on it. I wanted to thank you very much for the help that gave me ......

Valeu even personal !!!!!!!!!!!