Error on create foreign key in oracle

[GoogleCodeExporter]

What steps will reproduce the problem?
- Use Database.AddForeignKey with oracle provider

What is the expected output? 
- create a foreign key

What do you see instead?
- ORA-00905: missing keyword because ON UPDATE NO ACTION ON DELETE NO
ACTION its not oracle keyword

What database and version are you seeing this issue on?
- Oracle 10g, migrator.net 0.7

Please provide any additional information below.
- I am override AddForeignKey method in OracleTransformationProvider. I am
not write tests because it exists but not pass, now they passing.

Thanks

Original issue reported on code.google.com by joa...@gmail.com on 1 Jul 2008 at 9:44

Attachments:

• foreignkey_oracle.diff

[GoogleCodeExporter]

hi,

i am fix addcolumn for a exist table. in oracle not exist column key word in 
alter table:

ALTER TABLE WORKFLOW ADD COLUMN WORKFLOW_SOURCE NUMBER(10,0) : sql ok, oracle 
fail

ALTER TABLE WORKFLOW ADD WORKFLOW_SOURCE NUMBER(10,0) : oracle ok

Original comment by joa...@gmail.com on 24 Jul 2008 at 6:43

Attachments:

• foreignkey_addcolum.patch

[GoogleCodeExporter]

SVN 109
Applied patch. I don't have Oracle to test unfortunately.
Someone who uses Oracle, please run unit tests and report any problems.

Original comment by geoffl...@gmail.com on 4 Aug 2008 at 11:02

• Changed state: Fixed
• Added labels: Milestone-8