db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From robk99 <ROBEKL...@TX.RR.COM>
Subject Default Value of SYSDATE not set in Oracle TIMESTAMP column
Date Sat, 13 Oct 2007 20:28:19 GMT

I have an xml file that includes a table with the following columns defined.

      <column name="ISACTIVE" primaryKey="false" required="true" type="CHAR"
size="1" default="Y" autoIncrement="false"/>

      <column name="CREATED" primaryKey="false" required="true"
type="TIMESTAMP" size="7" default="SYSDATE" autoIncrement="false"/>

Both columns are created in the table within the Oracle database.
The "ISACTIVE" default value is created correctly with a value "Y".
The "CREATED" default value is left blank.

Is this a bug or is setting a timestamp column default value not allowed in
Ddlutils?  Should I be using a different value other than SYSDATE?

Thanks for any help!

View this message in context: http://www.nabble.com/Default-Value-of-SYSDATE-not-set-in-Oracle-TIMESTAMP-column-tf4619496.html#a13193025
Sent from the Apache DdlUtils - User mailing list archive at Nabble.com.

View raw message