Hello Tom,

I am working in a project with the goal of creating a new structure to our database
where we want to be able to manage the resources in a better way.
And separate the objects that we are creating from those that ours clients developers.
And the idea that we have is to crate a single trigger in each table that will serve us as a dispatcher to other business rules that our clients need.
And each of those rules would be inside a procedure that our trigger would be calling and controlling the time spent and resources.



Is this even possible?
We tried to came up with some examples to pass those information to the procedure but we don't know if this is a good practice
or/and if this will work on cases where we have multiple row being change and large field as clob and blob?
How would that affect our system?

Can you give me some idea if this strategy is a good one to take?