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: David Pattinson <david_at_addease.com.au>
Date: Tue, 01 Jun 1999 09:33:03 +1000
Message-ID: <37531C2F.6033E4C6@addease.com.au>


What error did you get? Was it a mutating table error?

David.

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.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon May 31 1999 - 18:33:03 CDT

Original text of this message

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