Oracle8, object schema, REFs in nested table

Hello,
can somebody help me with the object schema in Oracle8 ? ( REFs in nested tables )

For example, if I have the object schema ( it is from the Oracle8 documentation ):

   CREATE TYPE emp_t AS OBJECT ( eno number, ename char(31));    CREATE TYPE emps_t AS TABLE OF REF emp_t;    CREATE TABLE emptab OF emp_t;
   CREATE TABLE dept (dno NUMBER, employees EMPS_T)

      NESTED TABLE employees STORE AS deptemps;

how can I access attributes from the table emptab, by means of REF in nested table employees of the table dept ???

Example:
SELECT e.eno FROM THE ( SELECT employees FROM dept WHERE dno=1 ) e;

this doesn't work - there is error message, that eno is bad column name.

Thank you.

Richard

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 16 1998 - 20:01:07 CDT