Re: One trigger operating on multipe tables .. possible ??

You'll need a trigger per table as far as I know. However, though, if the content of the trigger can be made generic you could always create a package for it. At least that way the bulk (not in this case as it only grabs sequence) of the trigger text for many triggers will be in a single spot and you'll only have one source.

--
Alan D. Mills




>

>My question is: How do I get my "primary_key_insert_trigger" to work on all

>the tables in my dB ?

>

>

>