Creation of a REF Request and REF Passing Method Set

Figure 1: OOERD For Example Objects

As you can see from looking at the OOERD in Figure 1, we have the two object tables, their main types and a single method in each. The code to implement this structure is shown in listing 2.

CREATE OR REPLACE TYPE BODY emp_t IS
MEMBER FUNCTION give_ref(id IN integer)
  RETURN REF emp_t  IS
  ref_val REF emp_t;
BEGIN
  SELECT REF(e) INTO ref_val
  FROM employees e
  SEE CODE DEPOT FOR FULL SCRIPTS
END;
END;
/
 
CREATE or replace TYPE company_t (
   company_name          VARCHAR2(32),
   company_business     VARCHAR2(32),
   company_contact        name_t,
   contact_home              VARCHAR2(20))
/
 
rem
rem The job_sites object is an independent one-to-many
rem from employees. We will REF emp_t and EMPLOYEES
rem

SEE CODE DEPOT FOR FULL SCRIPTS

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