|Subject||Re: [firebird-support] Triggers|
Mahesh Ishwar wrote:
>Thanx for ur prompt response.Yes, though more commonly that is done with view triggers.
>In my existing Oracle database, I've to write a statement level trigger becoz of th eproblem of mutating table restriction describe as under :
>".... the mutable table restriction on row level triggers (which says records in the table originating the trigger or or as a part of cascade delete can not be mutated by the tigger."
>I just wanted to know is this possible in Firebird that a trigger which is evoked after an insert in a row does some calculation on some other tables and then deletes this row itself?