Re: Triggers for updating tables at particular time interval

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 Tue Jun 01 1999 - 01:33:03 CEST