Re: Triggering on selects

In article f0j_at_nemesis.muppet.bt.co.uk, crawford_at_strat-sys.bt.co.uk (Ben Crawford) writes:
>I want to fire a trigger when a SELECT operation is performed on a table,
>potentially FOR EACH ROW. I'd be very interested in hearing if
>anyone out there knows a way of doing this in Oracle V7!
>
>I want to do this in order to populate parts of the table as it is being
>read - by making calls to other data stores. I need to do this 'on request'
>because I am dealing with a large volume of volatile data, so keeping my
>Oracle table fully in step with the rest of the world is not feasible.
>
>Any suggestions welcome; thanks for your time,
>Ben.
>
>
>

Sorry, no SELECT triggers here! I don't know enough about your data, but a VIEW or a PACKAGE may be more appropriate to provide Just-in-Time data.

Hope this helps.

Sincerely,

Martin Farber
Independent Oracle Consultant

                        |  NYNEX Science & Technology
                        |  500 Westchester Ave, Rm 1D10
                        |  White Plains, NY  10604
                        |     -----------------
                        |  email: farber_at_nynexst.com
                        |  Voice: 914/644-2656
                        |    FAX: 914/644-2216