Re: on delete set null

From: Doug Cowles <dcowles_at_us.ibm.com>
Date: Mon, 10 Jan 2000 21:52:45 -0500
Message-ID: <387A9AFD.1E96A96@us.ibm.com>

Doese anyone know of some arcane alternative view I can look at? Can I decode it myself? It is frustrating to be designing a data model and have no idea which constraints
are on delete set null.
Secondly, does Oracle have plans to fix this? Thanks,
Dc.

Erwin Dondorp wrote:

> Doug Cowles wrote:
> > I am happy that on delete set null works in Oracle 8i. However, I see
> > no confirmation of it's implementation in user_constraints. The delete
> > rule still specifies NO ACTION ENBLED, even though it is clearly
> > implemented with add contraint xyz foreing key (id)
> > refereneces othertable(id) on delete set null.
> > What am I missing?
> > - Dc.
>
> You are missing nothing.
> There is an error in the data dictionary view.
> It decodes only the case "CASCADE" and decodes all others as "NO
> ACTION".
> I found this while writing a reverse engineering program for database
> objects.
>
> Erwin
>
> --
> Erwin Dondorp
> <http://www.dondorp.com/>
Received on Mon Jan 10 2000 - 20:52:45 CST