Oracle_adapter...ora-00907

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.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs