Re: Multiple triggers on the same table

First of all, thank you for your time. :)

Sybrand Bakker wrote:
>
> Of course: the Oracle Application Developers Manual states that Oracle
> doesn't guarantee the sequence of triggers.
> Your statement about not knowing whether triggers exist is void: you
> can easily look that up in user_|all_|dba_triggers.

Things aren't so simple. I don't have access to the database I am referring to, so I cannot have any view of the existing triggers and definately, I cannot merge any triggers. I am working on the production database and all the changes will be applied on the dissemination database and those databases are geographically separated (periodically synchronised by sending sql files). Above that, I would like a more general solution so that it can be applicable to other databases too. Till now, I have made my triggers not to cause any troubles to other existing triggers. But, in the case that an existing trigger is been executed before and it deletes the row, I will face some problems. That's why I wanted to force the execution of my trigger first.

I guess you can't always have anything you want in life!!

Regards,

Vangelis Received on Thu Feb 06 2003 - 16:01:50 CET