Getting a REF to object in nested table.

Is it possible to get a reference to an object in a nested table?

this query:
select value(nv)
  from table (select nested_table

                from parent_table
               where some_value = 'something' )nv;

returns the values for the objects in the nested table. However, replacing "value" with "ref" results in an ORA 00904 "invalid column name" error on the first line.

thanks Received on Fri May 12 2000 - 00:00:00 CDT