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.

</R>