Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: ssantiago on April 16, 2011, 02:51:44 pm

Title: Oracle 11g data types are not listed within EA.
Post by: ssantiago on April 16, 2011, 02:51:44 pm

When doing data modeling for an Oracle DB, I don't see all the Oracle 11g data types.  Do I have to manually define these if they are missing?  Here are the data types defined in 11g - not all are shown in EA:

http://download.oracle.com/docs/cd/E18283_01/appdev.112/e10646/oci03typ.htm#insertedID2

In particular, the BINARY_DOUBLE, BINARY_FLOAT, and TIMESTAMP data types.

In the Resources section of the Additional Downloads site I saw additional data type files for Access and SQL Server 2008/2005, but not for 11g.  Are these available anywhere?

Thanks,

Sam

Title: Re: Oracle 11g data types are not listed within EA
Post by: Eve on April 19, 2011, 08:25:34 am

What build are you using? The release notes say that interval and timestamp were added in build 858.

However, if your model was created before then, you may need to export the datatypes from the base model because they won't exist in your current model.

Title: Re: Oracle 11g data types are not listed within EA
Post by: ssantiago on April 19, 2011, 09:23:39 am

Yes, I am using build 858 - Program Version 8.0.858 (Build:858) - Unicode.  I created a new project as a test, but don't see any of the new Oracle data types:
http://www.softitechture.com/EA-oracle-types.png