Path: text.usenetserver.com!out03a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!club-internet.fr!feedme-small.clubint.net!feeder.news-service.com!138.199.65.86.MISMATCH!sn-xt-ams-06!sn-xt-ams-04!sn-ams!sn-feed-ams-01!sn-ams!sn-feed-ams-02!sn-post-ams-02!sn-post-sjc-01!supernews.com!corp.supernews.com!not-for-mail From: sybrandb@hccnet.nl Newsgroups: comp.databases.oracle.server Subject: Re: Dynamic Search Conditions using PL SQL Date: Wed, 13 Jun 2007 00:52:05 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: <9q8u63pqpjncqe4o7lmqjkfqqvfiaba5jf@4ax.com> References: <1181635054.204151.321510@x35g2000prf.googlegroups.com> <1181661907.861770.227670@j4g2000prf.googlegroups.com> <1181677067.592920.251330@x35g2000prf.googlegroups.com> X-Newsreader: Forte Agent 4.2/32.1118 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 16 Xref: usenetserver.com comp.databases.oracle.server:429077 X-Received-Date: Tue, 12 Jun 2007 18:53:05 EDT (text.usenetserver.com) On Tue, 12 Jun 2007 19:37:47 -0000, Valentin Minzatu wrote: >I never did an impact analysis between implementing dynamic SQL and >VPD and I do not know neither the business case nor the usage/size/etc >of the database hence the question (as opposed to affirmation), but >from the example it looks like it may be the case for it or for >implementing something along those lines. VPD is always in use, even during export. It is only disabled when SYS exports the database. Still think this is a viable suggestion to avoid dynamic sql? -- Sybrand Bakker Senior Oracle DBA