CREATE OR REPLACE TYPE order_item_typ AS OBJECT ( order_id NUMBER(12) , line_item_id NUMBER(3) , unit_price NUMBER(8,2) , quantity NUMBER(8) , product_ref REF product_information_typ ) ;