Re: on delete set null

From: Erwin Dondorp <erwindon_at_wxs.nl>
Date: Mon, 10 Jan 2000 23:21:24 +0100
Message-ID: <387A5B64.F0E0E5C5@wxs.nl>

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 - 16:21:24 CST