Re: on delete set default feature

From: Digeratus 2006 <digeratus2006_at_nospam.hotmaildotcom>
Date: 16 Jun 2007 01:49:33 GMT
Message-ID: <Xns9950DEC60247digeratus2006@63.218.45.20>

dondora <koninja_at_bluebottle.com> wrote in news:1181951732.498838.314930 @i38g2000prf.googlegroups.com:

> hi.
> I want to create tables like below.
>
>

[snip]
>
> But errors has occured like this.
> , FOREIGN KEY(staffNo) REFERENCES Staff ON DELETE SET DEFAULT
> *
> ORA-03001: unimplemented feature
>
>
>
> Can't I use 'ON DELETE SET DEFAULT' feature in ORACLE?
>
>

Nope,
CASCADE or SET NULL
RTFM @ http://download-east.oracle.com/docs/cd/B19306_ 01/server.102/b14200/clauses002.htm#i1002156

sorry about the word wrap

HTH
Andy Received on Fri Jun 15 2007 - 20:49:33 CDT