Creation of a REF Request and REF Passing Method Set

CREATE OR REPLACE TYPE site_t as object (
  site_id                          INTEGER,
  company                      company_t,
  address                       address_t,
  employee_id_r             REF emp_t,
MEMBER FUNCTION get_ref
   (emp_id IN integer)
   RETURN REF emp_t)
/
 
rem
rem job_sites is an object table definition
rem
 
CREATE TABLE job_sites OF site_t
     (employee_id_r WITH ROWID
      SCOPE IS employees)
      OIDINDEX oid_job_sites (TABLESPACE raw_index)
       PCTFREE 10 PCTUSED 80
       INITRANS 5 MAXTRANS 255
       TABLESPACE raw_data
       STORAGE ( INITIAL 20m NEXT 10m
                           MINEXTENTS 1 MAXEXTENTS 10
                          PCTINCREASE 0
                        )
/

SEE CODE DEPOT FOR FULL SCRIPTS

http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm