 |
|
Using Object IDs (OIDs)
in Oracle 8
Oracle Tips by Mike Ault |
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
 |
For more information on this topic, I recommend Don
Burleson's latest book "Oracle
Tuning: The Definitive Reference".
You can buy it direct from the publisher for 50%-off and get
instant access to the code depot of Oracle tuning scripts: |
http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm
 |
Expert Remote DBA
BC is America's oldest and largest Remote DBA Oracle support
provider. Get real Remote DBA experts, call
BC Remote DBA today. |
 |
|