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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Package with invoker's rights (8.0)

Re: Package with invoker's rights (8.0)

From: Christophe Courtois <christophe_at_courtois.cc>
Date: Sat, 28 Sep 2002 10:03:41 +0200
Message-ID: <an3nhp$2ig9$1@norfair.nerim.net>


> One way is to have some code in a before update trigger do something
> compare the result to an appliation table and raise an exception when
> necessary.

 Good idea. But I have to keep track of all tables which could be potentially updated, I must not forget to add some if the package evolve, and it's not a good thing for heavily updated million-rows tables :(

-- 
Christophe Courtois 
http://www.courtois.cc - Clé PGP : 0F33E837
----------------------------------------------------------------------
Received on Sat Sep 28 2002 - 03:03:41 CDT

Original text of this message

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