Hi Madhavan
Thanks to you and Jonathan for the input.
Another question on the same subject. How are policies defined for child tables. For example if you have an parent table which has say company id so you define a policy on this column. now a parent child related table, the child table is related to the parent and thus has no company id. Now how would one define a policy on this table to take into account the policy defined on the parent table.
Basically select from child table where foreign key matches the rows of the parent and also meets the policy defined on the parent.
Menon
Madhavan Amruthur <[EMAIL PROTECTED]> wrote:
Hi Murali,
In our case since the predicats are generated dynamically and a call to
the function from outside will give me the predicate being applied.
Thanks to Jonathan Lews, I will also make sure now using event 10730.
Regards,
Madhavan
http://www.dpapps.com
> Thanks for the response. I did get it working. However I have another
> question. Have you tried to capture what happens behind the scene. I
> turned on trace however could not trace the actual query that gets added
> to the SQL statement. Only the function call could be traced not the
> actual SQL condition
>
> Thanks
>
> Menon
--
Madhavan Amruthur
DecisionPoint Applications
--
http://www.fastmail.fm - Choose from over 50 domains or use your own
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Au! thor: Madhavan Amruthur
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, and more
