Data models: Oracle NUMBER fields

[Emilio]

In Oracle (using 10g) you can define a number field as follows:

NUMBER
NUMBER(precision)
NUMBER(precision, scale)

When you create a structural diagram and drop a TABLE object into it I make sure it has Oracle as the database type.

In my field I specify NUMBER but the bug in EA v7.1.831 is that when you define a NUMBER field you MUST specify both scale and precision even though in Oracle you can just use the first format (NUMBER).

There is a workaround but nevertheless it remains a bug. The work around is that in the model you have to set both scale and precision to zero (0) because it does NOT accept empty, NUMBER(0,0) which is misleading to say the least.

[«Midnight»]

Hi Emilio,

I remember something about this from a while ago, it might have been since 831 came out. 832 came out about 7-8 weeks ago. Have you had a chance to test the problem on 832 yet?

Given that it has been almost two months, 833 should also be around the corner.

Please post back with an update when you get the chance to test on either or both of these newer builds.

David

PS: Meanwhile I'll watch the Release Notes page when new builds come out.

[LAJO]

Hello I am a noob with EA!  

I am modelling an ER-Diagramm with EA! when i am adding a new Table I then continue with selecting a Database (right klick->General->Datab.) I am choosing a ORACLE DB!!
then i would like do add some Colums! and here my problem starts!!
I want to add a Colum with the Datatype INTEGER but it doesn't show up at the dropdown that i am getting. (right klick->Tabel Detail-> Colums/Atributes..->klick-> DATA Type)
Because i can't select an integer I instead added a Number Datatype with prescion 8 and scale 0!
I recongnized if I am selecting mysql as Database then the Integer Datatype appeers in the Dropdown!

Does Anybody know why i can't select Integer under Oracle??
pleaz help..
thx JO

[«Midnight»]

Search my posts - go back a few months - for how to set the default database in a more effective manner. Use the keywords EABase and DBMS.