Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: important : deleting rows with PL/SQL
"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
![]() |
![]() |