Re: ON DELETE SET NULL shown as NO ACTION

From: Gilles PARC <gparc_at_online.fr>
Date: Mon, 24 Jul 2000 21:39:10 +0200
Message-Id: <10568.112817@fatcity.com>

At 08:04 24/07/2000 -0800, you wrote:
>I find that the delete_rule of ON DELETE SET NULL is shown as NO ACTION in
>user_constraints in my database. ON DELETE CASCADE is shown correctly.
Real NO
>ACTION is shown correctly too (although I hope it's shown differently so I
can
>tell the difference). Can anyone confirm this to be a bug?

Hi Yong,

Yes it's a bug in catalog.sql (8.1.5 & 8.1.6) :

the views ALL/USER/DBA_CONSTRAINTS
are incorrectly defined BUT nevertheless and as you noticed, the set null constraint is truly enforced.

I don't have the bug number at hand now, but you can obtain a patch from Oracle support.

HTH Regards

Gilles Parc
Email : gparc_at_mail.dotcom.fr Received on Mon Jul 24 2000 - 14:39:10 CDT