cascade delete

From: Sajit Kalidas <sajit_at_infowave.co.za>
Date: Fri, 16 Nov 2001 13:40:51 +0200
Message-ID: <3bf4fae8$0$227@hades.is.co.za>

Hi there,

I need to write a generic delete procedure to delete all master and details records to an unknown number of levels. I am looking for suitable suggestions on how to approach this.

I have so far thought of the following, but I do not want to use it since it requires too much control and opens the database up to data inconsistency:

drop and recreate all contraints (using all_constraints) to use the ON CASCADE DELETE option. Delete the topmost master table and then drop and recreate the constraints again with the default NO ACTION option.

I would appreciate any other suggestions on how to approach this.

Many thanks

Sajit Received on Fri Nov 16 2001 - 05:40:51 CST