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.