Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Are Triggers Really that Bad or ....???

Re: Are Triggers Really that Bad or ....???

From: David Fowler <dbf57_at_earthlink.net>
Date: Fri, 26 Jul 2002 03:39:01 GMT
Message-ID: <pv309.6805$Ky3.394851@newsread2.prod.itd.earthlink.net> 





To avoid coding it over and over. create a oracle type with these columns
and put it in the tables. Create a package with  procedure/function handle
insert /update.


Call the package from the insert,update trigger. passing the type. Code is
centrally controlled within the package the oracle type is all the tables.



just a little object orientation.



Dave Fowler
Received on Thu Jul 25 2002 - 22:39:01 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US