Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is there a trigger available for when a record is selected?
Ok, but I am unlikely to get the time for several weeks (perhaps even months)!
Karen Abgarian <abvk_at_ureach.com> wrote in message news:<3E095854.2F97B95E_at_ureach.com>...
> How about trying this B yourself and letting everybody know if it works?
> Should not be so difficult to do. At the first glance, Oracle should not
> allow you to create the view, failing with something like 'function does
> not garantee not to update the database'. You can probably work around
> this by hiding your inserts in a dynamic sql, and use a pragma to declare
> that you are not updating anything. It will likely compile and it will maybe
> crash with an ORA-600 down the road.
>
> You certainly know about audit and that it can be used to record sql.
>
>
>
Received on Wed Jan 08 2003 - 04:15:52 CST