is just a rant.
In 40-odd tables in a schema 4 columns are exactly the same (name,
datatype, constraints). Example: created_uid, created_timestamp,
modified_uid, modified_timestamp.
So I want my trigger to fire on insert or update and slap in the
values. Easy enough, when you create the triggers for ever single
table. We're talking close to 80 some triggers with the exact same
code. :(
Now I know I can call a stored procedure (which incidentally runs
faster than triggers), but is there any way to pass the bind variables
like :new.colName?
If it were possible it would mean only one place for my code, rather
than 80. So my question is what does :new.colName really bind to?
I'm sure you are asking, why don't you just try and see? Well my
answer is simple, the stupid dbas neglected to give me an account on
the new server, and I wont be able to demman one until tomorrow.
Oh well. Anyone have a work around?
-Adam
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
