Hi ... I am trying to create a sample table in oracle using db:migrate and it gives me the following error. OCIError: ORA-00907: missing right parenthesis: CREATE TABLE comics (id NUMBER(38) NOT NULL PRIMARY KEY(38), title VARCHAR2(255) DEFAULT NULL NULL, issue NUMBER(38) DEFAULT NULL NULL, publisher VARCHAR2(255) DEFAULT NULL NULL, created_at DATE DEFAULT NULL NULL, updated_at DATE DEFAULT NULL NULL) If i remove the ''default null null'' keywords manually and run it in sqlplus I am able to create the table. Why is the oracle_adapter creating the statement with syntax that does not work in oracle ? How do I fix this ? It is rails 2.1.0 and I am using the oracle_adapter I got from http://svn.rubyonrails.org/rails/adapters/oracle/lib/active_record/connection_adapters/oracle_adapter.rb (It is not working with the earlier version of oracle_adapter.rb either (The one that is bundled with the ruby-oci8 install)) (Full oracle client). I am running this against an 11g database. Thank you very much for your help with resolving this. </R> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---