Data Model: Oracle RAW (size)

[mariec]

Hi,

Is there a way to set the size of a RAW type field in a data model diagram?

The generated DDL never includes this type of information and Oracle requires a size for a RAW field.

Thanks

[Bruno.Cossi]

Hi,

try going to the menu Configuration > Database datatypes and modify the RAW definiton there (actually, you may have to delete it and create a new one).

Hope this helps!
Bruno

Hi,

Is there a way to set the size of a RAW type field in a data model diagram?

The generated DDL never includes this type of information and Oracle requires a size for a RAW field.

Thanks

[mariec]

Thanks for the tip! I had to play around, the pre-defined datatypes can't be deleted so there are two options:

- play around with the "ddl_datatypes.xml" before you create your project

- create a new RAW datatype, delete it. This deletes both RAW types. Then recreate it again

I had to do with second option since my project was too advanced to start all over.

Thanks again

[Bruno.Cossi]

You're welcome! It might be worth reporting it to Sparx as a bug, too.

Bruno

Thanks for the tip! I had to play around, the pre-defined datatypes can't be deleted so there are two options:

- play around with the "ddl_datatypes.xml" before you create your project

- create a new RAW datatype, delete it. This deletes both RAW types. Then recreate it again

I had to do with second option since my project was too advanced to start all over.

Thanks again