Customizing Oracle Query Handling

From: <grp.anon_at_gmail.com>
Date: 16 Nov 2006 19:39:10 -0800
Message-ID: <1163734750.754399.106650_at_h48g2000cwc.googlegroups.com>



[Quoted] Hi there,

[Quoted] [Quoted] Is it possible to intercept queries on the Oracle Server prior to processing and encompass some rules around how the queries are processed?

For e.g. Depending on varying parameters I may want to deny users querying capabilities or forward them to another instance or modify queries based on hints contained in the queries etc.

Is it possible to do this kind of query management in Oracle? I guess I essentially want to wrap some logic behind how/when queries are responded to by my oracle database. Can I embed oracle into a custom application to do something like this?

I have been unable to find something relevant to this, I'm sorry if this is a repeat. Any help appreciated.

Thanks very much,

GrpAnon Received on Fri Nov 17 2006 - 04:39:10 CET

Original text of this message