Re: Cascade Deletes

From: zfred <zfred_at_ozemail.com.au>
Date: Fri, 20 Nov 1998 09:40:51 +1100
Message-ID: <36549E73.EB4A0AE@ozemail.com.au>

I have to deal with such a person on this project...
complains stored procedures are too difficult, triggers hide things happening from
the application developer,etc,etc,etc
You know one of those persons who is completely lost if there is no visual GUI debugger
to SEE the code!!!

I try to pacify by saying that the server side is strictly trying to deal with referential integrity, although i would personly do more on the server side if possible but
can't be botherd arguing the points anymore....what do you say to such a person
(i've been doin stored procs/triggers over couple years now)

Thomas Kyte wrote:

A copy of this was sent to "Manoj Goel" <mgoel@jps.net>
(if that email address didn't require changing)
On Tue, 17 Nov 1998 21:18:47 -0800, you wrote:

>hi Guys,
>
>  I have been asked to not to use cascade deletes in our app which is
>running on
>  oracle 7.3 . But I thought that if it is an option provided by the RDBMS
>then why
>  not use it ?
>
>  What could be disadvantages??
>
> Please help me understand it.

we would have to first understand the motivation of the individual making the
rule to not use database features.  They might like 'explicit' code and want the
apps to delete all children programatically before deleting the parent.  ON
DELETE CASCADE would allow a single record delete to silenty delete many other
records without the application knowing about it, they just might not like that
idea.

>
> Thanks
>
>  Manoj
>
>
>
>
 

Thomas Kyte
tkyte@us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/    -- downloadable utilities

----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation

Anti-Anti Spam Msg: if you want an answer emailed to you,
you have to make it easy to get email to you.  Any bounced
email will be treated the same way i treat SPAM-- I delete it.

Received on Thu Nov 19 1998 - 16:40:51 CST