Re: polling a table

You can use dbms_job to run a procedure every hour. Jim
"Ed prochak" <ed.prochak_at_alltel.com> wrote in message news:e51b160.0202070550.6d9d21db_at_posting.google.com...
> vikas_sikka_at_rediffmail.com (Vikas Sikka) wrote in message
 news:<ff72404c.0202060956.30eb3d79_at_posting.google.com>...
> > hi
> > I want to poll a table and then take data from it and then populate
> > multiple table from that data
> > which one is the best solution
> > 1.Writing a stored procedure called from a trigger
> > 2.making an application
> > any elaboration with example would really be appreciated
> >
> > thanks in anticipation
> >
> > Vikas Sikka
> > vikas_sikka_at_rediffmail.com
>
>
> Depends on what you mean by "poll". To me that implies some periodic
> process, which would be difficult to do with a trigger procedure
> (there is no "trigger on the HOUR" option AFAIK).
>
> As for examples, I'm sure the oracle manuals have ones showing
> procedures reading one table and populating others. Surely you do not
> want us to write the code for you.
>
> When you encounter some problems in your code, please come back with
> more specific questions.
>
> Have a nice day.
> Ed Prochak
> Magic Interface, Ltd. (http://www.magicinterface.com)
>
> (Contracting to, but not speaking for, ALLTEL)
Received on Fri Feb 08 2002 - 08:17:02 CET