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 -> Cascade update within trigger

Cascade update within trigger

From: Richard Fairbairn <r.fairbairn_at_zetnet.co.uk>
Date: Wed, 2 Sep 1998 22:08:45 +0100
Message-ID: <1998090222084576740@zetnet.co.uk> 





I wish to update primary key column in my table. Is it possible to 
use a trigger to update foreign key column values to reflect this 
change? I've tried, but get an error stating that what I am 
attempting is not allowed. However, I'm led to believe it can be 
achieved somehow. Please help!



Best wishes



R.


Received on Wed Sep 02 1998 - 16:08:45 CDT












Original text of this message













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