Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Access user-defined type column remotely
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,
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. Received on Mon May 24 2004 - 17:04:24 CDT
![]() |
![]() |