Problem with an SQL statement

Question

I'm having a problem with an SQL statement. I want to activate a "ON UPDATE CASCADE" behavior for a foreign key in a table with this statement :

ALTER TABLE "DB"."RECORD" ADD CONSTRAINT "RECORD_PT_OUTIL_FK1" FOREIGN KEY ("CDE_PO")
REFERENCES "DB"."PT_OUTIL" ("CDE_PO") ON UPDATE CASCADE ENABLE;

But when i run the statement in Oracle Developer, i just get this error message : "ORA-00905 : missing keyword" I can't find what could be this missing keyword, i tried several changes but always the same error occurs. I reuse a code generated by Oracle Developer it self and just modify it with what i want. This is the generated code :

ALTER TABLE "DB"."RECORD" ADD CONSTRAINT "RECORD_PT_OUTIL_FK1" FOREIGN KEY ("CDE_PO")
REFERENCES "DB"."PT_OUTIL" ("CDE_PO") ON DELETE CASCADE DISABLE;

See, i just change the end of it. So what's the matter here ? Am i missing something ? (please don't bash if it's something obvious :) ) Thx !

user330315 · Accepted Answer · 2011-04-07 06:42:29Z

1

Oracle does not support the ON UPDATE clause for foreign keys.

See the description of the REFERENCES clause in the manual:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/clauses002.htm#CJAIHHGC

answered Apr 7, 2011 at 6:42

user330315

Sign up to request clarification or add additional context in comments.

Comments

Jagmag · Accepted Answer · 2010-10-11 10:49:11Z

0

Try by removing the DISABLE/ ENABLE at the end of your command

As per the ADD CONSTRAINT reference, there doesnt seem to be any "Enable / Disable" as part of the command.

I think it is something that your Oracle Developer is adding at the end (it being part of Oracle Syntax) and it might be causing the problem!!

answered Oct 11, 2010 at 10:49

Jagmag

10.4k1 gold badge37 silver badges60 bronze badges

2 Comments

B1ll0u Over a year ago

I give you the DDL generated to create the Table, maybe you'll see something weird ... :

Jagmag Over a year ago

@B1ll0u - what db engine are you using in MySQL? Is the table in question using MyISAM or InnoDB?

Collectives™ on Stack Overflow

Problem with an SQL statement

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related