Book a Demo

Author Topic: DDL for userDefined types  (Read 1712 times)

duhlar

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
DDL for userDefined types
« on: January 29, 2008, 03:31:52 pm »
working with OR-ORACLE

How do I gen DDL for userDefined types?

Something like:
CREATE TYPE StockItem_objtyp AS OBJECT (
StockNo NUMBER,
Price NUMBER,
TaxRate NUMBER
);

for:
CREATE TYPE LineItem_objtyp AS OBJECT (
LineItemNo NUMBER,
Stock_ref REF StockItem_objtyp,
Quantity NUMBER,
Discount NUMBER
);

only <<table>> stereotypes seem to appear in the DDL generator pick list.

I also tried to reverse engineer an OR-Oracle model and the types couldnt be picked there either. They imported as BLOBS.

What did I miss?