Should I Define CASCADE on Database Table or Forms ?

[xtanto]

Hi All,

We are developing Forms 10g application on Oracle 9i.
The question is :
For best practice on Master Detail application, should I define
cascade on database level or Forms level ?

Thank you foryour help,
xtanto

[Niall Litchfield]

"xtanto" <krislioe@gmail.com> wrote in message
news:e1c9bd55.0409280308.39fac60a@posting.google.com... Hi All, We are developing Forms 10g application on Oracle 9i. The question is : For best practice on Master Detail application, should I define cascade on database level or Forms level ?

Will you allow non forms access to the app via any means (sql loader/ query
tools/ dbas with sqlp*plus etc)?


--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

[Daniel Morgan]

xtanto wrote: Hi All, We are developing Forms 10g application on Oracle 9i. The question is : For best practice on Master Detail application, should I define cascade on database level or Forms level ? Thank you foryour help, xtanto

You have provided insufficient information from which anyone could
formulate a response.

Do you want this behavior to only exist in the Forms application
or to apply to any changes made to the data, perhaps by a DBA,
using SQL*Plus?

--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[xtanto]

Hi,

Is 'whether the data only accessed from Forms app or other app' the
only factor to be considered here ?

Will it be a problem if a table has 15 - 20 cascaded FKs refering to
it ? will this cause performance issue ?

Thank you,
xtanto

Daniel Morgan <damorgan@x.washington.edu> wrote in message news:<1096518045.239319@yasure>... xtanto wrote: Hi All, We are developing Forms 10g application on Oracle 9i. The question is : For best practice on Master Detail application, should I define cascade on database level or Forms level ? Thank you foryour help, xtanto You have provided insufficient information from which anyone could formulate a response. Do you want this behavior to only exist in the Forms application or to apply to any changes made to the data, perhaps by a DBA, using SQL*Plus?