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

Home -> Community -> Usenet -> c.d.o.server -> Re: Triggers for updating tables at particular time interval

Re: Triggers for updating tables at particular time interval

From: Simon Hedges <shedges_at_hhhh.freeserve.co.uk>
Date: Tue, 1 Jun 1999 11:36:50 +0100
Message-ID: <7j0d2b$sa3$1@news7.svr.pol.co.uk>

<atul0305_at_my-deja.com> wrote
> I am working on a stock exchange type of project ,which is my first
> project in oracle. I have created tables which store details of
> differnt kind of bonds,no of purchased shares,no of sold shares and
> price of the shares.The current price in the table has to be updated
> at a particular time interval(which has a formula to calculate)
> depending on the number of shares sold and bought by the players.
> As the curr price changes, portfolio value also has to change,at the
> same time. I have written stored procedures which will update the curr
> price and portfolio value, for the whole table, But when I called the
> same procedure in trigger, giving time range it is not working.So would
> like to know the proper way of writting and executing triggers in
> Oracle 8.Also i would appreciate if someone helps me in writing this
> particular trigger of price and portfolio updation at a regular
> interval.

If you want to do things in Oracle at a particular time interval, try using the DBMS_JOB package to trigger them off.

Simon Hedges
Gloucester
UK Received on Tue Jun 01 1999 - 05:36:50 CDT

Original text of this message

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