ON DELETE SET NULL does not work???

From: Sergey Balter <balter_at_kompas.donetsk.ua>
Date: Wed, 2 Oct 2002 11:46:21 +0300
Message-ID: <anebpc$jgq$1@dipt.donbass.net>

Hi,

A am trying to alter table and add constraint

ALTER TABLE Lot
ADD FOREIGN KEY (ProductId)
REFERENCES Product (Id)
ON DELETE SET NULL; There are no error messages.

But when I check what happens with

SELECT * FROM USER_COSNTRAINTS
WHERE Table_Name = 'LOT'

I've got 'NO_ACTION' instead of 'SET NULL' in DELETE_RULE field.

 CONSTRAINT_NAME     CONSTRAINT_TYPE        TABLE_NAME         DELETE_RULE
  SYS_C0075654                   R
LOT                         NO ACTION

I use Oracle 8.1.7

Regards,
Sergey Balter Received on Wed Oct 02 2002 - 03:46:21 CDT