Re: polling a table

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 Thu Feb 07 2002 - 14:50:15 CET