# Oracle\_adapter...ora-00907

**URL:** <https://www.ruby-forum.com/t/oracle-adapter-ora-00907/143641>\
**Category:** Rails\
**Created:** [July 21, 2008, 1:37pm UTC](https://www.ruby-forum.com/t/oracle-adapter-ora-00907/143641 "2008-07-21T13:37:18Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![rajeev](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/ec9cab/32.png) [@rajeev](https://www.ruby-forum.com/u/rajeev)\
**Post date:** [July 21, 2008, 1:37pm UTC](https://www.ruby-forum.com/t/oracle-adapter-ora-00907/143641/1 "2008-07-21T13:37:18Z")

</div>

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](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.