Show Posts
1
General Board / 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?
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?