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>