Re: GEN: Generate DB Trigger from table

"Steven C. Kondolf" wrote:

> Hello -
>
> I have a requirement to generate Oracle Appliation table triggers for
> a specific schema (i.e. INV) and am wondering if anyone has or knows
> of a script that will generate the sql to create the triggers by
> reading from the Oracle Tables. Ideally I'd like to supply the schema
> and have the script create all the trigger code.
>
> I was able to go in and "cut-n-paste" them from Enterprise Manager but
> that was very time consuming especially for a large group of tables.
>
> We're on 8.0.5 of the database (11.0.3 of the apps).
>
> Thanks for any help.
> Peace,
> Steve
> skondolf_at_garbage.rochester.rr.com

If the triggers are all identical ... why not just have a simple trigger that calls a procedure.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)