Re: enabled trigger doesn't fire

Richard Gjerde wrote:

> I have administrator rights on the database, so I don't think it has to do
> with user rights. What I am really testing is an application that does
> inserts in a table which has a trigger that should insert into another
> table. I know the application is doing this correctly, but I have also
> checked it by manually inserting via SQL Plus Worksheet doing commit without
> any more success. The trigger does not have any exception handling. (It is
> very straightforward, it is highly unlikely that the triggered insert should
> fail if the original insert worked.) Just as an experiment I made two new
> identically defined tables (just two columns) and made a lame trigger which
> would insert the same in the second table on insert in the first. I could
> not even get this to work. I inserted into table1, but nothing happended
> with table2.

I think that if you can't understand this problem you should not have administrator rights. Who game them to you and why?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)