Re: important : deleting rows with PL/SQL

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 20 Jan 2004 10:50:10 +0100
Message-ID: <400cf969$0$17136$626a54ce@news.free.fr>

"philippe" <jftek_at_hotmail.com> a écrit dans le message de news:400CF8C8.3010302_at_hotmail.com...
> hi,
>
> Is it possible to use "DELETE ON CASCADE" with stored PL/SQL procedures
> or have we to make the deletions of foreign keys manually with some
> "fetch" and "select" ?
> In this last case must we put them in the procedures of deletion or in
> triggers ?
>
> thanks
>

Why not using ON DELETE CASCADE when creating the foreign key?

Regards
Michel Cadot Received on Tue Jan 20 2004 - 03:50:10 CST