Forum Stats

  • 3,780,928 Users
  • 2,254,456 Discussions
  • 7,879,497 Comments

Discussions

Unpredictable behaviour on (some) properties on DDL generation

I have a table with an identity column and an XMLTYPE column.

I have followed all the steps to be able to generate the identity column properties (e.g. setting the auto increment and identity option in the design and in the physical model).

However, when I open my design and generate the DDL I observe 2 things:

  • The identity column properties are NOT in the DDL
  • Some physical properties of the XMLTYPE column are added to the DDL, in uppercase, but not all.

When I then inspect the physical model and verify that all these properties have been set correctly I generate again and now:

  • The identity column properties are in the DDL
  • More physical properties of the XMLTYPE column are in the DDL, howver, in lower case, more (default properties) as in the previous generation, and an empty line between some of these properties (causing the DDL to fail)

If needed I can supply my design to reproduce it.

Comments