CREATE OR REPLACE TYPE warehouse_typ AS OBJECT ( warehouse_id NUMBER(3) , warehouse_name VARCHAR2(35) , location_id NUMBER(4) ) ;