Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Triggers on Views fire for table?

Re: Triggers on Views fire for table?

From: Ed Prochak <edprochak_at_magicinterface.com>
Date: Wed, 05 Dec 2001 13:11:09 GMT
Message-ID: <3C0E4824.6DB06D50@magicinterface.com>

Luch wrote:
>
> Anybody have ideas how to get around or a good way to deal with this. I was
> given only select access to a certain view, I don't even know what table
> it's coming from. I want to process each record as it comes into the view
> (just like an insert trigger on a table).
>
> --
> Luch
> replace nospam with usa for e-mail.
>

Each record only "comes into the view" when you access the view.

Are you then modifying the records or just doing something like updating an on-screen display? You may have to set up a periodic process to monitor the view and process new records as you see them.

If you are going to modify these records then actually the correct solution is to get the trigger set on the real table (or tables). If you code the trigger properly, you should be able to lobby the DBA to install it. If it is really necessary for your project, then your manager should be able to support your request.

-- 
Edward J. Prochak   --- Magic Interface, Ltd.
Ofc: 440-498-3700
on the web at       --- http://www.magicinterface.com
email: ed.prochak_at_magicinterface.com
Received on Wed Dec 05 2001 - 07:11:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US