Re: Access user-defined type column remotely

cschang wrote:

> I have two separate databases schema (local, remote) location at
> different machines. One of the tables on the remote schema is
> constructed with a user-defined column such as
>
> create or replace type a_t as object
> ( a varchar2(1),
> b number(5,2)
> );
>
> create or replace type a_nt as table of a_t
> /
>
> create table my_tbl
> (
> c varchar2(2),
> d a_nt,
> primary key ( c) using index tablespace i_index
> ) ..
> nested table a_nt store my_tbl_tab..
> /
>
> How can I, from schema of here, access the detail info b in column of d
> of the my_tbl on schema remote? My system is 8.1.6 on NT 4. I have
> created a remote database link from the schema here to remote.
>
> I have found some papers mentioning this subject on Asktom, but it
> limits the non-user-defined column? Because it defined a rowtype type
> of the remote table, however it cannot be used on the table containing
> object type.

8.1.6 is Paleolithic so I can't recall what you would do in it. But in any case one solution would be to write a view on the remove server that unnests the object and presents you with a purely relation view of the data.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)