Re: temp. undo delete in trigger / cascade delete via trigger..

>have you tried defining the foreign key constraint
>as "deferrable" or "deferrable initially immediate" ?
>(not available prior to Oracle 8.0 )

we still have to support ora 7.3.4..

to get out of this circle i think i'll alter my tables to cascade delete and raise exceptions in my triggers if it's not explicitly enabled for that session.

ciao, jan

http://www.rsp.de/

rs&p-Dossier: Software zur Erstellung technischer Dokumentationen

              und Schriftgutes in Verwaltung und Industrie. Received on Sat May 27 2000 - 00:00:00 CDT