Re: Oracle 9i VPD Predicate Function

From: Chris McMahon <NOSPAM_cochrane68_at_hotmail.com>
Date: Sat, 04 Jun 2005 07:19:55 -0400
Message-ID: <o7goe.33772$Fv.29970@lakeread01>

Jonathan Lewis wrote:
> "Chris McMahon" <NOSPAM_cochrane68_at_hotmail.com> wrote in message
> news:4Z6oe.33725$Fv.7401_at_lakeread01...
>

>>I've observed that the predicate function we wrote for the policy against 
>>a table is firing twice for each query against that table.  Is this normal 
>>behavior for VPD Predicate Functions?

>
>
>
>
> The function is embedded in an anonymous pl/sql
> block that is executed on each parse call and each
> execute call.
>
> If you had a sample of code that held cursors, you
> would see that you get one execution of the predicate
> function per execution of the cursor.
>
> This is normal for 9i onwards. 8i did not do this.
>

I'm new to VPDs, and I'm not sure I totally understand what you said. Are you saying that my simple SQL statement:

SELECT * FROM test;

is first parsed (1st row in log table added) and then executed (2nd row in log table added)? Received on Sat Jun 04 2005 - 06:19:55 CDT