Generating DDL for Oracle

[HUBERT-JR]

I want to generate a DDL form a Database-Table Design made in EA. I have defined a table which consists of three rows, one of them is ID from type NUMBER. I expect EA to generate a DDL where the statement should be:
CREATE TABLE name-of-table (
   NAME VARCHAR2(100),
   CODE VARCHAR2(10),
   ID NUMBER NOT NULL
);          
but generated was
CREATE TABLE name-of-table (
   NAME VARCHAR2(100),
   CODE VARCHAR2(10),
   ID NUMBER(15,-4840) NOT NULL
);

How can I change the generation for that???

[«Midnight»]

Don't know.

But I'd take a look at your settings for the column, including the advanced tab and the various index and unique check boxes.

Also, take a look at the settings on the code generation form that comes up - it is so easy to just press Generate - and see if tweaking them has any effect.

[HUBERT-JR]

Thanks for your comment. I've already tried, but cannot see any differences. Any other proposals?

[«Midnight»]

Try giving your NUMBER column a specific length (in the EA model). What happens now?

[HUBERT-JR]

I tried nearly everything. As results I got something like:
ID NUMBER (8,2)

Thats better than what I had before, but I need to have:
ID NUMBER

Any more ideas?

[«Midnight»]

Sorry, nothing off-hand.

Perhaps someone else has solved this in Oracle. Chime in folks!

[hd]

See EA Help Data Modeling | Create Columns.

Half way down the page is a note relating to setting up Oracle NUMBER datatypes.

[«Midnight»]

Thanks Henk,

It's been so long since I did an Oracle model I simply forgot.

David